Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003
    Location
    The Netherlands
    Posts
    1

    Unanswered: SQL 2000Transaction log backup job Failed

    I made a transaction log backup job, running every night at 10.00pm, but it won't run. I get an error message:

    SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan 'db-maint'' (0x714C193CE9C4A74C80C28002766AE3D1) - Status: Failed - Invoked on: 2003-03-19 22:00:00 - Message: The job failed. The Job was invoked by Schedule 6 (Schedule 1).

    Can somebody explain to me what i can do to fix this problem?
    The database backup method is FULL so i can make transaction log backups.

  2. #2
    Join Date
    Jul 2002
    Posts
    63
    You can do the following :

    1. In the maintains plain set the DB to be full Back Up once a day
    2. Set the Transaction log to back Up every 1 hr / 30 Min according to the number of transaction / size of each back
    3. configure the back up to delete old back up


    In order to start the back up now just make full back up of the DB , than shrink the transaction log , and than Back up again the DB .

    Now you can start he schedule job of the the maintains plain and it should be O.K

    Eyal

Posting Permissions

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