How To Export SQL Server Database As .MDF File

Gagan Sharma

Database ServicesExport SQL Server database as MDF File.MDF and .LDF files

13 Comments

Join the conversation! Your thoughts help the community grow.

Onkar Sharma6y ago
Very Well explained. Thanks for sharing with us...
Satyaprakash Samantaray9y ago
In real time no one follow up by using this process , everyone using by taking script of schema of objects and data..... So, kindly tell this process why we use in real time.... By the way mdf and ldf files more big in size but script very less size compare to mdf and ldf.
- Gagan Sharma9y ago
  This is also an example to follow any approach the user want.
- Idris Adeleke6y ago
  Since you know the real time process, why not add it as your comment and teach everyone instead.
Subash10y ago
Great one
Santhakumar Munuswamy10y ago
Thanks for nice article
Yashwant Vishwakarma10y ago
Nice article, thanks for sharing !!
Humayun Kabir Mamun10y ago
Nice...
Sibeesh Venu10y ago
Nice Share
Ravi Patel10y ago
nice share
Ankur Mistry10y ago
Nice Article
Abhay Shanker10y ago
Nice Share
Raja T10y ago
Nice, thanks for sharing

Sometimes our requirements are related to opening the existing database on some other location system so that we can access it or we can further modify it. For this SQL Server Management Studio 2014 provides the functionality to perform this task.

Exporting a database is very important in cases where DBA or developer or any user has to access it on any other location.

Example: Working on any database at office or college or at home, if you want to export and open that database so that you can use later on, you need to understand the steps to export the database.

Here are the steps stating the procedure of exporting a database,

Firstly, go to SQL Server Management Studio, right click on your database and select properties. Now select File menu,

In File option, you need to get the Path of database saving location with files name saved as .MDF and .LDF files.

Second, Open the path location as given in above pic and copy both the .mdf and .ldf files of database that you want to export.

Third, before copying .mdf file and .log file on your system please Stop services of your SQL Server,
To Stop services: Search Services in your system search option, then select your Sql Server Name and right click on its Properties and click Stop option.

Example

Fourth, now the database files (.mdf and .ldf) are saved on your system. Just copy them to other places through pendrive or email or any other way to export the database to destination system.

Example

Fifth, Now on your destination system just copy or cut and paste both the .mdf and .ldf database files in to the MS SQL Server path location on your system:

Sixth, Open your SQL Server Management Studio 2014 of destination system, here right click on Databases folder and select Attach option.

When you clicked Attach, a window will open, In this just click on Add button, select the database .mdf and .ldf files and add it.

Just Refresh your databases, You can see that in below pic the database Trainee is exported from other system, now we can access its objects.