Steps Restore Database in sql server.
- Create database in Sql server
connect to the sql server--> right
click on databases--> new database
2. Copy the database backup file into
database server.
3. Restore Database
Right click on the database ---->
tasks-->restore-> database
4. Select From Device Radio button and
browse for the .bak file in the database server.
5. Click on Ok
6. Select the latest back up .
7. Then go to options and check over
write Existing database check box
8. click on ok.
Database is Restored Successfully.





