Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


advertisement
 

Restoring Your Database Safely

SQL Server has added powerful capabilities to the recovery process, such as creating a standby database. Unless you know how to use the RESTORE command properly, however, you risk losing data.


advertisement
s I've shown in my previous 10-Minute Solution, "Choosing the Right Backup in SQL Server," SQL Server provides you with numerous ways to back up your database, allowing you to choose the options that best suit your situation. However, the best backup solution comes to naught if you don't know how to restore your backups. Unless you know how to use the RESTORE command properly, however, you risk losing data.

In this 10-Minute Solution, I walk you through the RESTORE command and demonstrate its various options.



SQL Server has added powerful capabilities to the recovery process, such as creating a standby database. Unless you know how to use the RESTORE command properly, however, you risk losing data. What are the various options of the RESTORE command and when should you use them?



  1. The RESTORE database command will recover a complete database from a full backup.

  2. Use RESTORE FILELISTONLY in conjunction with the MOVE option when you need to move files to different locations.

  3. Always use the NORECOVERY option unless you are sure you are finished applying your backups.

  4. The WITH STANDBY option allows you to use run queries on your backup database.

  5. The RESTORE DATABASE command is also used for differential backups.

  6. To apply file backups, you need to issue both the RESTORE DATABASE and RESTORE LOG commands.


Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date