none
SQL Backup, second incremental fails RRS feed

  • Question

  • Hi,

    I trying to use DPM to backup my SQL server, but some of the databases fails at the second incremental.

    DPM error message:

    Recovery point creation jobs for SQL Server 2005 database RUMSK01WW99\CCRS_DB on rumsk01ww99.danfoss.net have been failing. The number of failed recovery point creation jobs = 1.
     If the data source protected has some dependent data sources (like a SharePoint Farm), then click on the Error Details to view the list of dependent data sources for which recovery point creation failed. (ID 3114)

    DPM tried to do a SQL log backup, either as part of a backup job or a recovery to latest point in time job. The SQL log backup job has detected a discontinuity in the SQL log chain for  SQL Server 2005 database database RUMSK01WW99\CCRS_DB since the last backup. All incremental backup jobs will fail until an express full backup runs. (ID 30140 Details: Internal error code: 0x80990D11)

    The most likely explaination would be that another software take an incremental backup in between DPM's, but I have tried manuelly taking 2 incremental right after eachother and I still get the error.

    I'm using DPM 2012 SP1 build 3408 and SQL 2005 SP4 build 5069.

    There are 10 non-sys databases on the server and they all have recovery model FULL.
    5 of the 10 databases have the problem.
    8 of the 10 databases are in read-only and 5 of those have the problem
    Databases mirroring or log shipping is not setup.

    Please help

    Best regards
    Martin

    Thursday, October 10, 2013 10:50 AM