Javatpoint Logo
Javatpoint Logo

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 "javatpoint" database into "javatpoint 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 "javatpoint restored".

All tables are reserved in the database as it is.

SQL Restore a database 5
Next Topic#




Please Share

facebook twitter google plus pinterest

Learn Latest Tutorials


B.Tech / MCA