SQL: DIFFERENTIAL BACKUP

MS-SQLSQL

Risk :

Missing differential backup may cause loss of data. In the case of database fault, we won’t be able to restore the database.

Description:

A Differential backup contains all the data in a specific database or set of file groups or files since the last Full backup.

A Differential backup cannot be executed without Full backup but it is smaller and faster to create than the base of a full backup and it also requires less disk space to store backup images

Normally:

Differential SQL backup should execute successfully every 24 hours.

What went wrong?

  • A large backup file causes long backup executes.
  • No available disk space.
  • The network is not available.

What to do:

  • Check the backup system.
  • Check server network connection

    Signup for the latest news and updates



    Share with friends:

    You may also like this:

    RECENT POSTS

    Menu