Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003

    Arrow Unanswered: database and log backup

    i set up database plan with database backup and log backup

    It does the database backup (1 am) while fails
    log backup set (at 10 am and 2 pm) when every one is using the database

    it as error as
    Backup can not be performed on this database. This sub task is ignored

    when i check event log
    event property
    SQL Server scheduled job 'Transaction log Backup Job for DB Main Plan1
    status failed Invoked on 2005-02-16 10.00.01 Message the job failed.
    The Job was invoked by schdeule 14( schedule 1) the last step to run was
    step1 (step1)

    Its not a right issue since only one part fails

    The only differenct is that i set log backup to be in subfolder of sqlbackup !

  2. #2
    Join Date
    Jan 2004
    In a large office with bad lighting
    User database or system database?

    Database recovery mode?

    Steps taken to troubleshoot on your own?

    Searched BOL and Knowledgebase?

    Try this for starters ...;en-us;303229

Posting Permissions

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