Restoring a SQL database with an .mdf file

SQL Server Ask the Experts

2585 pts.

Tags:

MDF

SQL Server database

How can I restore a SQL database with an .mdf file?

Asked: November 7, 2008 3:32 PM Last updated: November 20, 2014 12:41 PM

Answer Wiki

Last updated: November 20, 2014 12:41 PM GMT

clark445kent8,235 pts.
History
Contributors
- Ordered by most recent
- clark445kent8,235 pts.
- Denny Cherry68,390 pts.

Thanks. We'll let you know when a new response is added.

Hi,

I have Googled for this and found a helpful article for you http://smallbusiness.chron.com/restore-sql-database-mdf-file-46104.html
I hope it will assist you in resolving issues.

Thanks
& Regards

Clark
Kent

Discuss This Question: 4 Replies

JatinMuttreja Aug 15, 2010 3:04 AM GMT

you can do it by stopping SQL service from SERVICES AND APPLICATIONS. first create the database with same name, than after stopping sql service, just simply copy paste the MDF and LDF files from your backup.

10 pointsBadges:

report
Denny Cherry Aug 16, 2010 7:54 PM GMT

This won't always work, as the sizes will be different from the sizes of the files that are listed in the master database. Not to mention why would you stop the instance to do something which you don't have to take an outage to complete?

68,390 pointsBadges:

report
VinnySan37 Apr 30, 2012 11:58 AM GMT

You may restore sql database thanks to following software sql server fix tool will save all sql tables, stores and so on inside new .sql file

10 pointsBadges:

report
Brijesh Nov 19, 2014 6:47 PM GMT

You can restore the database by using the .mdf files as
EXEC sp_attach_single_file_db @dbname = 'database name',
@physname = 'C:\MSSQL\Data\database name.mdf'

14,450 pointsBadges:

report