Post reply

Phantom Backup Log

  • February 14, 2008 at 9:32 am

    #203481

    I have a 'Test' instance which keeps reporting "BACKUP failed to complete the command BACKUP LOG DBxxxxxxx. Check the backup application log for detailed messages." However, the instance has no jobs or maintenance plans which include any Backup Log steps with the command. It is a test instance and all of the db's are in 'simple' mode.

    How can I track down where or whom the command is issuing from? This is very perplexing.

  • February 14, 2008 at 9:46 am

    #778443

    John P Wood (2/14/2008)

    I have a 'Test' instance which keeps reporting "BACKUP failed to complete the command BACKUP LOG DBxxxxxxx. Check the backup application log for detailed messages." However, the instance has no jobs or maintenance plans which include any Backup Log steps with the command. It is a test instance and all of the db's are in 'simple' mode.

    How can I track down where or whom the command is issuing from? This is very perplexing.

    Hello John,

    You can check the activities that are happening on the box from Management --> Activity Monitor.

    You can have a SQL Profiler trace to capture all the happenings on the box.

    First of all, have you checked whether any maintenance plans are existing or else any jobs on the box. You can query the system tables for the maintenance plans. Please go through this BOL link

    http://msdn2.microsoft.com/en-us/library/ms190275.aspx

    http://msdn2.microsoft.com/en-us/library/ms189816.aspx

    Hope this helps.

    Thanks


    Lucky

  • February 14, 2008 at 11:30 am

    #778506

    this maybe a scheduled job running as a .cmd or .bat....check the servers scheduler as well.....

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

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