SQL Server BACKUP DATABASE is terminating abnormally: Problems with the query, "

  • tamil.selvanmca

    Ten Centuries

    Points: 1296

    Error Code-1073548784

    Executing the query "BACKUP DATABASE [DBName] TO  DISK = N'J:\\Differ..." failed with the following error: "Cannot perform a differential backup for database " DBName ", 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.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

    -------------------------------------------------------------------------------------------------------------------------------

    I was Create a Job for Full, Differential and Log Backup  of 10 Database

    Full Backup Every Sunday 12 AM

    Transactional Backup Every 6 hour Daily

    Differential Backup Daily 10.pm

    Full and Transactional run Success

    but Differential Only Fail.

    The issue occurred before one week

  • Cath Trimble

    SSCarpal Tunnel

    Points: 4197

    It looks like something has broken the LSN for that database .  That could be a switch from Full recovery to Simple and back, a restore, or another backup run outside your schedule.

    You’ll need to check the logs to identify exactly what the ‘something’ is.

Viewing 2 posts - 1 through 2 (of 2 total)

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