What's New in SQL Server Maintenance in SQL Server 2005?

Database snapshots Snapshots provide a way to revert to a point of consistency. A database snapshot records the current state of the data at the point when the snapshot is created. Any later active transactions are not included. You can later revert the database to the state it was in at the time of the snapshot.

Partial database restores Users can access databases when a partial restore is performed. Partial restores can occur against the database at the file or page level, while allowing users access to any unaffected files and pages. Users cannot access the part of the database being restored until it is recovered.

The CONTINUE_AFTER_ERROR option In SQL Server 2005, you can now continue the backup and restore operations after a failure. This option allows the process to continue even if it receives an error. If multiple problems exist, the administrator can assess the scope and then resolve the problem.

Fast recovery SQL Server 2005 Enterprise Edition allows fast recovery during crash recovery and mirroring failover. The data becomes available during the undo phase, with partial availability during restore operations, database page checksums, and backup media mirroring. The other editions of SQL Server 2005 do not let users access the database until recovery completes.

The RESTORE VERIFYONLY and BACKUP VERIFYONLY options If the TORN_PAGE_DETECTION or CHECKSUM database options are set, the VERIFYONLY option allows the integrity of data pages to be validated during backup and restore operations.

Mirrored backup sets You can perform backups to mirrored sets to reduce the impact of the possible loss or corruption of one of the backups. If a backup device fails, a backup mirror can be used to restore the database.

No comments: