Revision : Backups

Recovery Models

FULL Recovery Models

• Supports FULL , DIFF & LOG backups
• The only mode that supports PAGE restores - Page Restore requires FULL recovery model

SIMPLE Recovery Models

• Supports FULL & DIFF backups

Backup Options

COPY_ONLY Use this to take a copy of a production system for a development environment.
It won't mess up the backup chain.

CONTINUE_AFTER_ERROR - Does what it says!

BACKUP DATABASE database_name TO DISK='c:\database_name.BAK'
WITH CHECKSUM, CONTINUE_AFTER_ERROR;

It can also be used on a restore (last resort)

RESTORE DATABASE database_name FROM backup_device
WITH CONTINUE_AFTER_ERROR;