Restore a Database

In SQL Server, you can restore a database very easily. To restore a database right click on the Databases node. You will get a image like this:

SQL Restore a database 1

Click on the restore database.

SQL Restore a database 2

Enter the database name which you want to restore and the name of the database where you restore. Here we restore "syntaxbook" database into "syntaxbook restored".

SQL Restore a database 3

Click on the "ok" button.

SQL Restore a database 4

A new pop-up box will be appeared showing that the restoration of the database completed successfully.


# Check the Restored Database

Open Microsoft SQL Server Management Studio and click on the Databases. You will see the restored database "syntaxbook restored".

All tables are reserved in the database as it is.

SQL Restore a database 5