1 / 15

SQL Server webinar series #18

SQL Server webinar series #18. Don’t Lose Your Data: backup, restore and verification May 22, 2012 4-5PM (BST: GMT+1). Goals. Identify common backup problems Learn how to verify backups Use Red Gate SQL Backup Pro 7 to automate this process. Agenda. Common backup problems DBCC

graceland
Download Presentation

SQL Server webinar series #18

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. SQL Server webinar series #18 Don’t Lose Your Data: backup, restore and verificationMay 22, 2012 4-5PM (BST: GMT+1)

  2. Goals Identify common backup problems Learn how to verify backups Use Red Gate SQL Backup Pro 7 to automate this process

  3. Agenda Common backup problems DBCC CHECKSUM VERIFYONLY RESTORE SQL Backup Pro

  4. Grant Fritchey Product Evangelist for Red Gate Software Email: grant.fritchey@red-gate.com Twitter: @gfritchey Blog: http://www.simple-talk.com/community/blogs/scary/

  5. Common backup problems Inappropriate backup types Insufficient disk space Differential only Broken backup chain Corrupted backup file Improperly configured backups

  6. DBCC Backups are a page level copy of the database Check structure offline Still need to check physical structure

  7. CHECKSUM • Mathematical construct based on the page • PAGE_VERIFY • Not None • Validates page read & write • Not what is read or written • Stored with backup • Additional overhead on the system

  8. VERIFYONLY Validates Backup set Some header fields Checksum (if used in backup) Sufficient disk space Doesn’t check entire header

  9. RESTORE The only complete verification of a backup A backup is just a file until it gets restored Also verifies that you know how to restore

  10. SQL Backup Pro • Full support for properly configured backup • Automated restore testing • Reporting and alerting built-in

  11. Backup Testing • “You’re only as good as your last restore” - Kimberly Tripp • DBCC • Against Production • Against a Backup • CHECKSUM • Added overhead • VERIFYONLY • Header only without checksum • RESTORE • Like nuking from orbit, the only way to be sure

  12. Goals • Identify common backup problems • Learn how to verify backups • Use Red Gate SQL Backup Pro to automate this process

  13. Webinar registrants offer SQL Backup Pro 7 Exclusive discount offer for all webinar registrants Email: dba.info@red-gate.com Call: + 44 (0) 1223 437 921 Quote code “May webinar” 14-day free trial www.red-gate.com

  14. Grant Fritchey • Product Evangelist for Red Gate Software • Email: grant.fritchey@red-gate.com • Twitter: @gfritchey • Blog: http://www.simple-talk.com/community/blogs/scary/

  15. How would you… ? Questions? What happens when… ? Why does… ? When do I… ? This webinar is being recorded and the video will be available on www.sqlservercentral.com by Monday.

More Related