Backups and Restores
Backing up a database is one of the most important tasks that a DBA can perform. Therefore, after discussing the principles of backups, we look at some of the backup strategies that you can implement for SQL Server databases. We then discuss how to perform the backup of a database before we finally look in-depth at restoring it, including restoring to a point in time, restoring individual files and pages, and performing piecemeal restores.
Depending on the recovery model you are using, you can take three types of backup within SQL Server: full, differential, and log. We discuss the recovery ...