How to Restore SQL Server Database backup on window 7

How to  Restore SQL Server Database backup  on window 7

Steps:

1. Copy to backup files
 (Example copy two backup file MobileMaps.mdf and MobileMaps_1.ldf)
2. Navigate to 'DATA' folder of Microsoft SQL Server
 (Example 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA')
3. Paste copied files 

4. Open 'SQL Server Management Studio' file  from all program file
5. Login with valid username and password.
6. Right click on 'Databases' --> Attacted Database --> Add --> Browse to 'Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA' and select 'MobileMaps.mdf' file



2 comments: