Post reply

(64 DB) Backup scenario

  • May 14, 2008 at 8:23 am

    #207322

    i have a situation where i need to provide a backup plan for 64 databases all of which are running in full recovery mode.

    My questions is:

    1. should i create a backup script scheduled to execute all full backups of the 64 db's at once or should i schedule full db backups of these database to occur one after the other?

    thanks for yuor input guys

  • May 14, 2008 at 8:36 am

    #815253

    Denby (5/14/2008)

    i have a situation where i need to provide a backup plan for 64 databases all of which are running in full recovery mode.

    My questions is:

    1. should i create a backup script scheduled to execute all full backups of the 64 db's at once or should i schedule full db backups of these database to occur one after the other?

    thanks for yuor input guys

    Hi,

    Ideally, you may want to setup seperate backup schedules for each database to maintain a better level of control, as each database may have a different backup window in terms of other processes running. You can use a script to backup all databases in a sequential order, but I don't like such dependencies.

    This is really a question of backup management and putting together the best solution for your environment.

    Thanks,

    Phillip Cox

    MCITP - DBAdmin|MCTS - SQL Server 2000|MCP - SQL Server 2000

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

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