August 12, 2009 at 5:29 am
We have a productions server with 200+ databases. For BCP, we want to use log-shipping. What will be best method to configure the same.
1) Using right-click-on-database and ship transaction log (for each database)
OR
2) Manually scripting log backup/copy / restore jobs.
Because with 1st option, it will create 200+ log backup jobs...Has anybody implemented log-shipping for multiple databases.
Your suggestions can help me, in finalizing our BCP plan.
August 12, 2009 at 9:39 am
nitin.doshi (8/12/2009)
We have a productions server with 200+ databases. For BCP, we want to use log-shipping. What will be best method to configure the same.1) Using right-click-on-database and ship transaction log (for each database)
OR
2) Manually scripting log backup/copy / restore jobs.
Because with 1st option, it will create 200+ log backup jobs...Has anybody implemented log-shipping for multiple databases.
Your suggestions can help me, in finalizing our BCP plan.
Nitin,
It is not worth in configuring logshipping for 200 + databases as a BCP. Reason being upon configuring for logshipping it creates as many as database backup jobs on primary server and similar number of job for both copying and restoring on secondary server.
Also you have to ensure that jobs related to copying and restoration on secondaray server are to be staggered or else there will be resource contention when ever multiple restores and copying takes place with related to IO,Memory and CPU.
So it is better to have a DR server rather than doing logshipping as BCP Server. If you still want to implement logshipping I would rather suggest to implement important databases, other databases can be backed up and restored if required.
August 13, 2009 at 12:37 am
Thanks for your reply.. Can U elaborate little on DR (how to setup in General)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply