how to get .mdf database file from .bak file in asp.net c#

Question

helo sir, i have .bak file i have to convert it to .mdf file pls help me any code or link

Priyank Khare · Answer

I think following links will help you :- http://msdn.microsoft.com/en-us/library/ms190209%28v=sql.90%29.aspx http://forums.asp.net/t/1239529.aspx

Sanjay Kumar · Answer

Hi try this Backup database [database name] to disk='C:\dbname.bak' --or Backup database [database name] to disk='C:\dbname.bak' with stats=10

rajashri sarade · Answer

helo, thnx for reply but i would like to use .mdf file from .bak file which is form web server. actually i have downloaded from server. because when i run my application then it raise error as Warning: Fatal error 9001 occurred at Oct 24 2013 6:04AM. Note the error and time, and contact your system administrator. so i have to reload database so i want to restore it from .bak file. pls help me. any link or code thnx u.

Priyank Khare · Answer

The simplest way to do this all is through SQL Server Management Studio. If you don't have it (e.g. you're using SQL Server Express) then you should definitely download it and install it. Log in to your SQL Server instance in Management Studio then right-click on 'user databases', 'attach' then select your MDF file right-click on the attached database and 'tasks', 'back up'; use 'remove' and 'add' in the destination box if you want to change the filename.