Post reply

Backup databases and exclude some of the database

  • October 8, 2011 at 12:27 pm

    #246266

    We have 40 SQL servers, and we have maintence plan setup to back up all databases in SQL server, but sometimes some of the database really don't need to be backuped, so they are exceptions.

    I know I can select what databases need to be backup in the maintence plan, but I don't want to do that way, I 'd like to choose all the databases, so that if someone created a new databases, it will be automatically backed up.

    Is there a way to exclude database from maintence plan, it seems from interface, I cannot find that option. If there is one for script, that I can use to exclude database to be backuped, that will be great?

    Thanks

  • October 8, 2011 at 2:55 pm

    #1392109

    You probably won't be able to do this through maintenance plans. That's good because I believe that most folks recommend not actually using maintenance plans for various reasons.

    My recommendation would be a script and an exception table.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

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

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