Terabyte databases are no longer a rarity. SQL Server 2005 addresses problems with backing up and restoring these very large databases and provides greater recovery options for the VLDBs, as well as the smaller databases. In the final segment of this SQL Server backup and recovery series, Hilary Cotter looks at the new features in SQL Server 2005 to help DBAs provide high uptime and minimize the need for recovery. Features focused on include:
- Copy-only backups
- Mirrored tape backups
- Torn page detection's replacement - checksum
- Transaction marks
- Restoring from a database snapshot
SQL Server Research Library
