Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2004

    Unanswered: Transaction Logs


    When I look at the Database maintience plan history entry for backup I have a message that reads: "Backup can not be performed on this database. This sub task is ignored".

    Have anyone come across this error before?? As part of the Maintenance plan some transaction log are being backup and some aren't instead they receive the message above.



  2. #2
    Join Date
    Jul 2003
    San Antonio, TX
    The Recovery Mode for the database needs to be set to either Full or Bulk-logged. No non-logged operations can be performed for the database with those recovery modes to successfully back up the transaction log. Those operations include TRUNCATE TABLE for all Full and Bulk-Logged, and SELECT...INTO and BCP...IN/BULK INSERT for Full recovery mode.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  3. #3
    Join Date
    Feb 2004
    San Antonio, TX
    set your recovery model to full or bulk-logged
    in enterprise manager right click the database and select properties
    find recovery model on one of the pages (options i think)
    change the model click ok


    alter database DBX
    set recovery {FULL\BULK_LOGGED}

    BOOKS ONLINE [Selecting a Recovery Model]

Posting Permissions

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