SQL: Full backup (.bak)

Risk :

A missing full backup can cause loss of data. In case of database fault , we won’t be able to restore the database.

Description:

A full backup contains all the data in a specific database or set of file groups or files. It is the base of both differential backup and transaction log backup.

Normally:

Full SQL backup should execute successfully every 24 hours.

What went wrong?

  • A Large backup file caused long backup execute.
  • No available disk space.
  • Network is not available.

What to do:

  • Check backup system.
  • Check server network connection