|
|
|
|
When is a full backup required? Back
You need to perform a full database backup immediately after you have performed any one of the following actions, or you may be unable to use that backup with your last full database backup to restore the database successfully .
Created a new database
Changed the recovery model of the database
Changed the number of files or file groups in the database
Changed the arrangement of files among the file groups
Canceled a full backup job while it is running
Modified the structure of the database, including adding or removing a table or a column in a table
Added or removed an index
Restored the database from backups
|
|
|
Home