When is a sql server full backup required?

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