Post reply

Transaction Logs/recovery models & MP''s

  • January 18, 2007 at 7:04 am

    #115692

    Hi,

    I am aware that Transaction Log backups will fail if the recovery model of the database is set to simple (see http://support.microsoft.com/kb/303292) for SQL 2000 but has this been fixed for SQL 2005?

    Also does anyone know if a website exists of known bugs/problems with SQL 2005 Maintenance Plans?  I'm keen to know what they are prior to setting quite a few up.

    Regards,

    Mark

  • January 18, 2007 at 8:59 am

    #684037

    I've since found out that if you wish to backup the transaction logs of any database then that database recovery model must be set to Full.

    If anyone knows of any site/forum that is listing bugs etc with SQL 2005 Maintenance Plans I would be very interested to know the url.

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

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