Post reply

Cannot perform a differential backup for database "ReportServer"

  • February 14, 2013 at 12:19 am

    #274145

    Good day,

    Please assist Im getting the error below:

    "Cannot perform a differential backup for database "ReportServer"

    because a current database backup does not exist.

    Perform a full database backup by reissuing BACKUP DATABASE omitting the WITH DIFFERENTIAL option.

    BACKUP DATABASE is terminating abnormally."

    I have created a package for diff and full backups. My full runs once a week and diff runs daily as SQL Server Agent jobs. When I run the diff job manually it runs successfully and in the PoC it also runs successfully. I do have a full ReportServer backup. The log suggests that the full database backup does not exist but it does. I have created backup folders for diff and full but in the save drive.

    I'm not sure as to what else to check. Please assist.

    Thanks.

  • February 14, 2013 at 12:20 am

    #1587730

    I'm using SQL Server 2008.

  • February 14, 2013 at 12:38 am

    #1587733

    The error clearly says full backup is not availale.

    check any log truncation or shrink happened before the backup starts.

    try doing the fullbackup and then differenctial in sequence again.

    Regards
    Durai Nagarajan

  • February 14, 2013 at 2:11 am

    #1587765

    yesterday I changed the schedule so they can run sequentially full first then diff and it executed successfully using sql server agent. I then changed the times back to original ones and the diff failed. I do have a full backup.

  • February 14, 2013 at 2:21 am

    #1587768

    durai nagarajan (2/14/2013)

    check any log truncation or shrink happened before the backup starts.

    Neither of those will affect a differential backup base.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • February 14, 2013 at 2:22 am

    #1587770

    You have some third party tool backing up the databases as well as the native backups. My guess would be backupexec. The native and the 3rd part backups are interfering with each other causing this error.

    Ensure that you have native backups or 3rd party database backups, not a mix of both. Either will work fine, a mix won't.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • February 14, 2013 at 2:44 am

    #1587781

    Im not using any 3rd party. I created packages using SSIS 2008 tested successfully in dev, deployed to file system, this was running for 2 weeks every day without any issues, no changes have been made on the SQL box. All other jobs are running without any errors

    I have ran out of ideas, therefore, I have redeployed to SQL Server and modified my job steps to point to SQL Server instead of File System am now waiting for the job to execute.

  • February 14, 2013 at 2:58 am

    #1587785

    Check the error log, check the backup history tables, you have some 3rd party tool backing up your databases. Probably something one of your server admins put in place thinking it's a great idea.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • February 14, 2013 at 3:01 am

    #1587789

    GilaMonster (2/14/2013)

    durai nagarajan (2/14/2013)

    check any log truncation or shrink happened before the backup starts.

    Neither of those will affect a differential backup base.

    thanks that a good catch

    Regards
    Durai Nagarajan

  • February 14, 2013 at 9:46 am

    #1588000

    GilaMonster (2/14/2013)

    You have some third party tool backing up the databases as well as the native backups. My guess would be backupexec. The native and the 3rd part backups are interfering with each other causing this error.

    Ensure that you have native backups or 3rd party database backups, not a mix of both. Either will work fine, a mix won't.

    I'm pretty sure that at a previous place we had a huge database FULL backup directly to tape with BackupExec, and on occasion a native DIFF backup to disk without problems. Why would 2 different methods of full backup cause a problem ?

  • February 14, 2013 at 9:48 am

    #1588002

    homebrew01 (2/14/2013)

    GilaMonster (2/14/2013)

    You have some third party tool backing up the databases as well as the native backups. My guess would be backupexec. The native and the 3rd part backups are interfering with each other causing this error.

    Ensure that you have native backups or 3rd party database backups, not a mix of both. Either will work fine, a mix won't.

    I'm pretty sure that at a previous place we had a huge database FULL backup directly to tape with BackupExec, and on occasion a native DIFF backup to disk without problems. Why would 2 different methods of full backup cause a problem ?

    I've seen several cases where, for whatever reason, BackupExec invalidates the differential base. Haven't investigated why as I don't have it installed.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • February 14, 2013 at 11:15 pm

    #1588197

    Im strugggling to get rid of this error. Will post as soon as I have a solution

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply