Menu ▼



Posted By :
avatarLearn DotNet
Total Views : 796

Procedure for Restore of Sqlserver Databases

Restore of Database:

 Step 1:  Open Sql Server Management Studio and connect the database engine.

 

Step 2: Enter the To Database name.


Step 3:Select From Device and click on the browse button, then the following window will appear


Step 4:Click on Add Button , then the following window will appear

 

Step 5:. After selecting the backup file the following window appear.

Step 6: Click on OK Button in the above window then the following window will appear

 

Step 7: Select Restore button and  Select Options tab from the above window, the following will appear.


Step 10: select Overwrite the existing database option and then click on OK button 

Step 11: then you will find the below window says, Restore of database ‘Test’ completed successfully and then click on ok, then go to the database you will find all the tables, views, Stored procedures and etc.







comments powered by Disqus


Search dotnetlearners.com