Beginning Backup and Restore for SQL Server is the essential guide to discovering the power of data protection and loss mitigation in a SQL Server environment. A company that does not protect its data will not be a company for very long. This book will guide all levels of database administrator through the steps of creating an automated database backup and restore scenario. Too many database administrators rely on a generic maintenance plan to backup data. Catastrophic events can occur, and when they do, the seasoned DBA needs to have more than a generic backup available. This book will prepare any level DBA for these eventualities, bringing into focus such topics as backup rotation and retention periods, differing backup strategies, point-in-time restoration of data, and file/page restores.Recovering from a catastrophic failure used to be next to impossible. With the enhanced techniques and methods you will learn in this book, those failures can be reduced, if not eliminated. SQL Server provides a wealth of tools for backing up and restoring data; this book will help you to wield those tools successfully.