Database Restores

Database backups are like insurance policies—you have backups in case something bad happens, but you hope that you never need to use your backups. In the event you need to recover a database, SQL Server has several options that can be used to allow you to utilize your full, differential, transaction log, and/or filegroup backups to recover the maximum amount of data possible.

All restore sequences begin with either a full or filegroup backup. When restoring backups, you have the option to terminate the restore process at any point in time and make the database available for transactions. Once the database or filegroup being restored has been brought online, you can’t apply any additional differential or transaction log backups ...

Get Microsoft® SQL Server® 2008 Step by Step now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.