Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2008

    Post Unanswered: BACKUP failed to complete the command BACKUP LOG


    We are running scheduled tasks to truncate LDf files , We are using Tivoli TSM data protection for SQL for backing up files.While last run we came across this error while scheduled task was running.

    The error is as follows:

    BACKUP failed to complete the command BACKUP LOG [eRoom_eRoomSite] TO DISK = N'D:\Program Files\Microsoft SQL Server\Backups from F\eRoom_eRoomSite_tlog_200809240700.TRN' WITH INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT

    Any help will be appreciated.

    Rahul Parimal

  2. #2
    Join Date
    Jul 2003
    San Antonio, TX
    This error should be accompanied by other errors. Review the SQL errorlog for entries immediately preceeding or following this one, and you'll find the answer. Also check Application and System logs in EventViewer for the same time, so that you can correlate the problem with potential HW failure if one occurred.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts