Thursday 10 October 2024

BACKUP failed to complete the command BACKUP LOG DBname. Check the backup application log for detailed messages.

 Environment:

Taking SQL server 2016 Database backup through DPM Server 2016, The full backup and the consistency check was completing successfully but the differential backup was getting fail.

The backup was getting fail with the following error in DPM server.

Error:

Execution of SQL command failed for SQL Server 2016 database servername\databasename with the reason: . (ID 30173 Details: internal error code 0x80990D18)

Was getting the following error in the event viewer of the machine in which the SQL server was installed

Error:

BACKUP failed to complete the command BACKUP LOG ReportServer. Check the backup application log for detailed messages. 

Solution:

Change the Recovery model from Simple to Full, as mentioned below. 

On the SQL Server Database machine, open SQL server management studio, Extend Databases node--->right click on the effected database and select properties--->click on Options----> change the Recovery model to Full and click on OK

No comments:

Post a Comment