Post reply

maintence plan mark failed if one of the database is simple recovery mode

  • February 6, 2012 at 2:47 pm

    #264042

    We have a sql server 2005 sp2. In maintenance plan I recently changed a database to simple recovery mode according to our vendor. But the maintence backup plan failed with the following message:

    Database 'SurveyorDB' will not be backed up because it does not have its recovery model set to Full or BulkLogged.

    I know SQL server 2008 have no this problem. But from reading this article at the last paragraph it says it is fixed also in SQL 2005. But apparently not, what could be wrong?

    http://www.mssqltips.com/sqlservertip/1219/sql-server-transaction-log-backups-always-fail-with-maintenance-plan/

    It should realize it is a simple recovery mode and still mark the entire transactionlog backup job succeed.

  • February 6, 2012 at 2:50 pm

    #1443461

    That would be quite impossible as you cannot backup a transaction log for a database in simple recovery mode. The maintenance plan does not "change" unless you change it. It is really separate from the database engine and created using SSIS and then run using SQL Server Agent. You must go and manually edit your maintenance plan.

    Jared
    CE - Microsoft

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply