Jul 26, 2017 Aimbetter support

SQL: Differential backup
MS-SQL, SQL

Risk :

Missing differential backup may cause loss of data. In 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 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?

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

What to do:

  • Check backup system.
  • Check server network connection

 

 

 

 

 

 

You may also like this

Mar 24, 2018 Alon

SQL: Buffer Cache Hit Ratio

Reports the ratio of the data pages found and read from the SQL Server buffer cache and all data page requests. Pages that are not found in the buffer cache must be read from disk

MS-SQL, Performance, SQL
Apr 22, 2018 Alon

Host: CPU Utilization

Measures the load of all the tasks that are being performed by the server. CPU usage below 70% is considered normal. Unusual levels of CPU load activities may be coming from anti-virus scans, backups, restores etc.

Operating System, Performance, Windows

RECENT POSTS