Restoring a SQL database with an .mdf file

2585 pts.
Tags:
MDF
SQL Server database
How can I restore a SQL database with an .mdf file?
Asked: Last updated:
1

Answer Wiki

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

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • JatinMuttreja
    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
    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?
    69,005 pointsBadges:
    report
  • VinnySan37
    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
    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

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: