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

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 Kumar13y ago

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 sarade13y ago

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 Khare13y ago

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.