Post reply

transaction backup job in sql 2008

  • April 13, 2011 at 10:24 am

    #147786

    In SQL server 2005, if we have included a maintenance plan job to do transaction backup for all user databases, the job may fail if it includes a database with simple recovery mode, the job will fail.

    But I notice this is not happening in sql 2008.

    Is that true it's something fixed/improved in sql 2008?

    Thanks

  • April 13, 2011 at 10:34 am

    #1311172

    What Service Pack are you on ?

    Some 2005 maintenance plan problems were fixed with SP3. Not sure of the specifics though.

  • April 13, 2011 at 10:38 am

    #1311178

    SP2

  • April 13, 2011 at 11:42 am

    #1311213

    I think you should apply at least SP3. SP4 has been out a while now.

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

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