Post reply

failed to complete the command BACKUP LOG "TestDB" WITH TRUNCATE_ONLY

  • November 30, 2006 at 8:47 am

    #63014

    Guys,

    I have the following issue:

    In my SQL Server Logs I got the following error message: 'BACKUP failed to complete the command BACKUP LOG "TestDB"  WITH  TRUNCATE_ONLY'.

    I interpreted this message as "Backup failed for "TestDB" database"

    When I checked the "Database Maintenance Plan History", however, it says that this database was backed up and the backup was verified.

    Can anyone shed light as to when this message occurs and whether I am interpreting this correctly?

    Thanks a lot

  • November 30, 2006 at 8:55 am

    #674960

    backup log with truncate only means that it basically throws out the inactive part of the log, essentially taking away any chance of point in time recovery. it's usually used before you shrink the log file if it's too big.

  • November 30, 2006 at 9:40 am

    #674980

    So this message implies that this "inactive part throw out action" failed, right?

    What are the reasons it could fail and negative consequences of the failure?

     

     

    Thanks a lot

  • November 30, 2006 at 12:47 pm

    #675027

    Guys,

    I solved the problem.  Basically my db backup took longer today than usual.  While the backup was running, a defragmentation job started, where one of the steps in defragmentation (final step) is LOG TRUNCATION.

    There was some conflict between the two.

    This is why I got this error message and also (I did not mention this earlier), the defragmentation job failed.

    Scheduling defragmentation job a bit later should fix the issue.

     

    Thanks a lot

Viewing 4 posts - 1 through 3 (of 3 total)

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