Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2003
    Posts
    27

    Unanswered: Transaction log backup fails

    Hello

    The sql 2000 servers that I administrate seem to be unable to backup transaction log files. Other backups go fine (as long as they're local), but transaction log backups (even local ones) just seem to fail consistently.

    Here is the log file from this morning (I have camouflaged the domain name as *********):


    Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server 'ARES' as '*********\Administrator' (trusted)
    Starting maintenance plan 'DB Maintenance Plan2' on 20-08-2003 02:00:08
    Backup can not be performed on database 'DPregister'. This sub task is ignored.

    Backup can not be performed on database 'DPregister_test'. This sub task is ignored.

    Backup can not be performed on database 'ERPData'. This sub task is ignored.

    Backup can not be performed on database 'Import'. This sub task is ignored.

    Backup can not be performed on database 'LinkChecker'. This sub task is ignored.

    Backup can not be performed on database 'master'. This sub task is ignored.

    [1] Database model: Transaction Log Backup...
    Destination: [d:\Microsoft SQL Server\MSSQL\BACKUP\model\model_tlog_200308200200. TRN]

    ** Execution Time: 0 hrs, 0 mins, 1 secs **

    [2] Database model: Verifying Backup...

    ** Execution Time: 0 hrs, 0 mins, 1 secs **

    Backup can not be performed on database 'msdb'. This sub task is ignored.

    Backup can not be performed on database 'NetERP'. This sub task is ignored.

    Backup can not be performed on database 'Restore'. This sub task is ignored.

    Backup can not be performed on database 'ServiceAttest'. This sub task is ignored.

    Backup can not be performed on database 'Shuttle'. This sub task is ignored.

    Backup can not be performed on database 'TangTrold'. This sub task is ignored.

    Backup can not be performed on database 'USA'. This sub task is ignored.

    [3] Database VirkURLDB: Transaction Log Backup...
    Destination: [d:\Microsoft SQL Server\MSSQL\BACKUP\VirkURLDB\VirkURLDB_tlog_20030 8200200.TRN]

    ** Execution Time: 0 hrs, 0 mins, 11 secs **

    [4] Database VirkURLDB: Verifying Backup...

    ** Execution Time: 0 hrs, 0 mins, 5 secs **

    Backup can not be performed on database 'XML'. This sub task is ignored.

    Backup can not be performed on database 'blanketter'. This sub task is ignored.

    Deleting old text reports... 0 file(s) deleted.

    End of maintenance plan 'DB Maintenance Plan2' on 20-08-2003 02:00:44
    SQLMAINT.EXE Process Exit Code: 1 (Failed)


    As far as I can see only two of the transaction logs are backed up succesfully. The rest fail, causing the job to fail.

    Are there any special considerations when backing up these logs? Or any common errors? The only thing I can think of is that backup of the logs is started at the same time as backup of the DBs, and this might interfere (DB backup works fine though), so I've changed this now.

    Any help and/or suggestions will be greatly appreciated.

    MNJ

  2. #2
    Join Date
    Oct 2001
    Location
    Naples, FL
    Posts
    273
    Saw your post in sqlmag forums, are the databases that fail in simple recivery mode?
    ---------------
    Ray Higdon MCSE, MCDBA, CCNA

  3. #3
    Join Date
    Aug 2003
    Posts
    27
    Yes, the recovery mode seems to be the problem. For anyone else who are interested in this solution, here's the link:

    http://www.sqlmag.com/forums/message...82&STARTPAGE=1

    (I hope the admins of this forum don't mind me linking to another forum)

    MNJ

Posting Permissions

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