SQL: Full Backup (.bak or snapshot)

Risk :

Missing backup or snapshot can cause loss of data. In case of a 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.

A database snapshot is a read-only, static view of a SQL Server database (the source database). The database snapshot is transitionally consistent with the source database as of the moment of the snapshot’s creation.

Normally:

SQL Full backup or Snapshot should execute successfully every 24 hours.

What went wrong?

  • Large output file backup  long time backup.
  • No available disk space.
  • Network is not available.

What to do:

  • Check backup system.
  • Check SQL Full backup job.
  • Check server network connection