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.