RESTORING AN SQL DATABASE BACKUP USING SQL SERVER MANAGEMENT STUDIO
Fri, 15 Aug 2014

The SQL Server backup and restore component provides an essential safeguard for protecting critical data stored in your SQL Server databases. To minimize the risk of catastrophic data loss, you need to back up your databases to preserve modifications to your data on a regular basis. A well-planned backup and restore strategy helps protect databases against data loss caused by a variety of failures. Test your strategy by restoring a set of backups and then recovering your database to prepare you to respond effectively to a disaster.

Open SQL Server Management Studio and login to the SQL Server you want to restore the database to. It is best to either login as a Windows Administrator or as the SQL ‘sa’ user.

Once logged in Right click on the Databases and select Restore Database

Click the button next to From device under the Source for restore  to browse the location of backup file

Specify Backup location by clicking Add

Select the backup file

and click ok

Input the database Name

check Restore

Go to the options Tab Check Overwrite the existing database (WITH REPLACE)

Click ok

comments powered by Disqus