Kaseya Community

Unusually large incrementals (edit).

This question is not answered

Hi

I am using version 9.7-8218 of Kaseya Backup on a 2003 SBS sp2 box running SQL.  One of my locations has unusually large incremental backups, and I’m trying to discover the cause of these 6+gb incrementals each night.  Modified files from the previous day never reach the 6gb range, so I’m wondering what’s happening to cause the backup to get so big.

I have no errors in the Acronis logs (no big surprise since backups are successful), and some SQL errors which I researched and shouldn’t be causing the large backups.  Acronis has stated that these errors can be safely ignored in this forum:

http://www.wilderssecurity.com/archive/index.php/t-167162.html

Upgrading supposedly resolves those errors, but I digress…

Anyone have any ideas as to why such large incrementals?  Very little should be changing from Saturday to Sunday night at this location, yet incrementals still reach the 6GB range every day of the week.

 

Thanks,

BG



[edited by: Beatgrinder at 9:23 AM (GMT -7) on 8-2-2011] [edited by: Beatgrinder at 8:32 AM (GMT -7) on 8-2-2011] When pasting into body of message in IE9, it would show text but paste a blank message. Using Chrome to do the same thing seems to work.
All Replies
  • First thought is Exchange or SQL DB Changing size... also is shadow protect enabled (VSS)?

  • VSS enabled yes.  From what I understand, the incremental backups do a bit-by-bit comparison to create them, so only changes in the DBs will be written, is that correct?  I have other sites with nearly identical setups and run a 300-500mb backup each night.  There are only about 15 user mailboxes in exchange.

  • have you checked for defragmentation processes? if something is defragmented (files or database) the bits are changed and the (incremental) backup size will grow.

  • Darn! That was my next suggestion!

  • Great suggestion, I had already ensured no rogue defrag task was causing my problem.  I had a slew of SQL errors in my system log from last nights' backup, I'm suspecting the cause has something to do with SQL.  I will post pertinent errors shortly.

  • So at this same site, backups have failed 2 nights in a row, with error "Backup failed as the image location, \\nas\, was not available. Please verify the remote machine is turned on and Set Credential is correct.", though the NAS is fully accessible & functional...  Below are the SQL errors from two nights ago when the backup succeeded.  No errors in log on the past 2 night that they have failed, so they're definitely related:

     

     

    Event Type: Error

    Event Source: SQLWRITER

    Event Category: None

    Event ID: 24583

    Date: 8/1/2011

    Time: 11:56:08 PM

    User: N/A

    Computer: SERVER

    Description:

    Sqllib error: OLEDB Error encountered calling ICommandText::Execute. hr = 0x80040e14. SQLSTATE: 42000, Native Error: 3013

    Error state: 1, Severity: 16

    Source: Microsoft SQL Native Client

    Error message: BACKUP DATABASE is terminating abnormally.

    SQLSTATE: 42000, Native Error: 3271

    Error state: 1, Severity: 16

    Source: Microsoft SQL Native Client

    Error message: A nonrecoverable I/O error occurred on file "{1DBF1896-FCB2-456C-80FD-CF78CF39C496}3:" 995(The I/O operation has been aborted because of either a thread exit or an application request.).

    SQLSTATE: 01000, Native Error: 4035

    Error state: 1, Severity: 0

    Source: Microsoft SQL Native Client

    Error message: Processed 0 pages for database 'theWarehouseLocator', file 'theWarehouseLocator' on file 1.

     

     

    For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

    Data:

    0000: 53 51 4c 43 4f 4e 4e 43   SQLCONNC

    0008: 39 36 30 00 00 00 00 00   960.....

    0010: 53 51 4c 43 4f 4e 4e 43   SQLCONNC

    0018: 39 32 35 00 00 00 00 00   925.....

     

    ---------------------------------------------------------------------------(5 of the above errors in a row)

     

     

    Event Type: Error

    Event Source: SQLVDI

    Event Category: None

    Event ID: 1

    Date: 8/1/2011

    Time: 11:56:08 PM

    User: N/A

    Computer: SERVER

    Description:

    SQLVDI: Loc=TriggerAbort. Desc=invoked. ErrorCode=(0). Process=2676. Thread=652. Server. Instance=SQLEXPRESS. VD=Global\{1DBF1896-FCB2-456C-80FD-CF78CF39C496}2. 

     

    For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

     

    --------------------------------------------------------------------------------------(10 of the above errors in a row)

     

     

    Event Type: Error

    Event Source: MSSQL$SQLEXPRESS

    Event Category: (2)

    Event ID: 18210

    Date: 8/1/2011

    Time: 11:56:08 PM

    User: NT AUTHORITY\SYSTEM

    Computer: SERVER

    Description:

    BackupVirtualDeviceFile::SendFileInfoBegin:  failure on backup device '{1DBF1896-FCB2-456C-80FD-CF78CF39C496}4'. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.).

     

    For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

    Data:

    0000: 22 47 00 00 10 00 00 00   "G......

    0008: 12 00 00 00 53 00 45 00   ....S.E.

    0010: 52 00 56 00 45 00 52 00   R.V.E.R.

    0018: 5c 00 53 00 51 00 4c 00   \.S.Q.L.

    0020: 45 00 58 00 50 00 52 00   E.X.P.R.

    0028: 45 00 53 00 53 00 00 00   E.S.S...

    0030: 05 00 00 00 62 00 6b 00   ....b.k.

    0038: 75 00 70 00 00 00         u.p...  

     

    -----------------------------------------------------------------------------------(10 of the above errors in a row)

     

     

    Event Type: Error

    Event Source: SQLVDI

    Event Category: None

    Event ID: 1

    Date: 8/1/2011

    Time: 11:56:08 PM

    User: N/A

    Computer: SERVER

    Description:

    SQLVDI: Loc=SignalAbort. Desc=Client initiates abort. ErrorCode=(0). Process=3568. Thread=11476. Client. Instance=SQLEXPRESS. VD=Global\{1DBF1896-FCB2-456C-80FD-CF78CF39C496}5. 

     

    For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

     

    ----------------------------------------------------------------------------------------------(5 of the above errors in a row)

     

    The errors go in the same order I posted them, in the application log.  There are 5 SQL DBs, hence the errors are in groups of 5 & 10.  Not being so versed in SQL, any help is greatly appreciated.

  • Just an update:  After rebooting the NAS, backups resumed.  Unfortunately due to space issues, it created the synthethic full onsite and needs to offsite 50gb.  Fun.  Digressing again...

    Same SQL error set in the log after backups resumed.  Scratching a hole into my head on this one...