Friday, 11 November 2016

How to Restore Database from stored backup database using SQL Server Management Studio

This topic explains how to restore a full database backup using SQL Server Management Studio. When we are restoring a database from other instance.
To restore the database we need to follow below steps:
  • Copy Backup database to SQL server or any of Physical drive.
  • Connect to an instance of the SQL Server Database Engine and then expand that instance.
  • Right-click Databases and select Restore Database options like below:
  • Restore database wizard will get open select path and select backup database with .bak and click on ok.
  • On the file options select Log and Database path where you want to save.
  • On the Options path leave all default or modify as your requirement and click ok start recovery the database.
  • Once if you click on ok, backup database will showing on connected objected SSMS server.

See more about restore from technet:
Thanks ☺

No comments:

Post a Comment