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

    Unanswered: Transaction Logs

    HELP!!!!

    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.

    Thanks

    Lystra

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    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
    Location
    San Antonio, TX
    Posts
    565
    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

    OR

    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
  •