FULL Recovery Models
- Supports FULL , DIFF & LOG backups
- The only mode that supports PAGE restores - Page Restore requires FULL recovery model
- Supports FULL & DIFF backups
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;