SQL Server Backup and Restore

SQL Server Backup and Restore

A DBA's daily tasks are rarely constant; with one exception: the need to ensure that any database in their charge can be restored and recovered in the event of error or disaster. This book describes 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. Building your own automated solution will take a lot of work, but this books offers some advice on possible options, such as PowerShell scripting, T-SQL scripts and SQL Server Agent jobs.
Country USA
Manufacturer Red Gate Books
Binding Kindle Edition
ReleaseDate 2013-06-30
Format Kindle eBook

You might also like...