BACKUP AND RESTORE OF SQL SERVER DATABASES

By C. KIARS

CONTENTS BACKUP AND RESTORE OF SQL SERVER DATABASES RECOVERY MODELS BACKUP OVERVIEW RESTORE AND RECOVERY OVERVIEW BACKUP COMPRESSION FULL DATABASE BACKUPS PARTIAL BACKUPS FULL FILE BACKUPS DIFFERENTIAL BACKUPS COPY-ONLY BACKUPS TRANSACTION LOG BACKUPS TAIL-LOG BACKUPS BACKUP DEVICES MEDIA SETS, MEDIA FAMILIES, AND BACKUP SETS MIRRORED BACKUP MEDIA SETS BACKUP HISTORY AND HEADER INFORMATION POSSIBLE MEDIA ERRORS DURING BACKUP AND RESTORE COMPLETE DATABASE RESTORES (SIMPLE RECOVERY MODEL) COMPLETE DATABASE RESTORES (FULL RECOVERY MODEL) FILE RESTORES (SIMPLE RECOVERY MODEL) FILE RESTORES (FULL RECOVERY MODEL) APPLY TRANSACTION LOG BACKUPS ONLINE RESTORE RESTORE PAGES PIECEMEAL RESTORES RECOVER A DATABASE WITHOUT RESTORING DATA (TRANSACT-SQL) BACK UP AND RESTORE OF SYSTEM DATABASES BACKUP AND RESTORE: INTEROPERABILITY AND COEXISTENCE