SQL Server Backup and Restore PDF Download

Are you looking for read ebook online? Search for your book and save it on your Kindle device, PC, phones or tablets. Download SQL Server Backup and Restore PDF full book. Access full book title SQL Server Backup and Restore by Shawn McGehee. Download full books in PDF and EPUB format.

SQL Server Backup and Restore

SQL Server Backup and Restore PDF Author: Shawn McGehee
Publisher:
ISBN: 9781906434861
Category : Data recovery
Languages : en
Pages : 408

Get Book

Book Description
A database administrator's duties include ensuring that a database can be restored and recovered in the event of error or disaster. This book discusses how to perform backup and restore operations using SQL Server Management Studio (SSMS), basic T-SQL scripts and Red Gate's SQL Backup tool. Capturing backups using SSMS or simple scripts is fine for one-off backup operations, but any backups that form part of the recovery strategy for any given database must be automated with some built-in checks that, for example, alert the responsible database administrator immediately if a problem arises. The tool of choice in this book for backup automation is Red Gate SQL Backup. Building an automated solution will take a lot of work, but this book offers some advice on possible options, such as PowerShell scripting, T-SQL scripts and SQL Server Agent jobs. --