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 Aimbetter support

SQL: Buffer Cache Hit Ratio

SQL response delay cause application running slow.

MS-SQL, Performance, SQL
Apr 22, 2018 Aimbetter support

Host: CPU Utilization

CPU usage measure describes how much the processor’s are working. A server CPU usage level is depending on the tasks that are being performed by the process in the sever.

Operating System, Performance, Windows

RECENT POSTS