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