"sql - how to backup a database and export as a mdf file with ms sql 2008 r2" Code Answer

1

if you mean that you want to be able to attach the database on another server, then this is what you can do:

  1. detach the database (right click the database and click detach)
  2. copy the mdf and ldf files to your backup location
  3. attach the database (right click databases and click attach)

this is the path where you will find mdf file:

c:program filesmicrosoft sql servermssql10_50.mssqlservermssqldata
By Anduril on July 31 2022

Answers related to “sql - how to backup a database and export as a mdf file with ms sql 2008 r2”

Only authorized users can answer the Search term. Please sign in first, or register a free account.