Post reply

SQL agent Backups problem

  • July 31, 2008 at 4:35 am

    #191872

    Hi Team,

    I have a weird problem. My SQL server 2005 have two maintenance plans. One which takes backups of all system databases. and second one which take backup of all user databases. The issue is second plan only takes backup of few user databases not all. I mean to say here is user has created 22 databases but maintenance plan is only taking backup of 11 DB's.

    I noticed that when I'm selecting all user databases while creating another maintenance plan only 11 DB's are shown.

    Any help is really appreciated.

    Thanks,

    Hitesh.B

  • July 31, 2008 at 2:04 pm

    #851528

    One thing could be to check the compatibility level of your databases. Databases in compatibility level 70 are not displayed in the Maintenance Plans.

    http://msdn.microsoft.com/en-us/library/ms189647.aspx

    Ola Hallengren

    http://ola.hallengren.com

  • August 3, 2008 at 1:44 am

    #852404

    Thanks Ola. You are correct .. I have all databases in 70 mode. Let me see what I can do.

    Can we change the compatibility mode to 80? any risks?

    Thanks again Ola.

    Hitesh.B

  • August 3, 2008 at 2:06 am

    #852406

    You need to test your applications carefully after you have changed the compatibility level. There could be things that works in one compatibility level and not in another. If you decide to change the compatibility level you could just as well try to change it to 90.

    If you do now want to change the compatibility level now, you have to do your backups without using the Maintenance Plans. You could write your own T-SQL scripts. I have a set of maintenance stored procedures that you're welcome to use.

    http://ola.hallengren.com/sql-server-backup.html

    Ola Hallengren

    http://ola.hallengren.com

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

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