Best way to replicate / mirror 100s of databases in SQL 2005
Posted
by mrwayne
on Server Fault
See other posts from Server Fault
or by mrwayne
Published on 2009-09-06T22:28:05Z
Indexed on
2010/03/22
21:01 UTC
Read the original article
Hit count: 551
Hi,
I currently host around 400-500 SQL 2005 databases of varying sizes (1-10 gig) each. I am aware of most of the different methods available and the general pros/cons of mirroring, log shipping, replication and clustering, but i am not aware of how well they tend to perform when its employed at the size i have specified (400-500 unique databases).
Does anyone have any good advice on what is likely the best method for having the ability to fail over to another server with this sort of setup?
Fail over does not need to be immediate, i'm just looking for something better than taking backups every day and moving them to storage. I'm preferably looking for something that would also makes it easy to manage the databases in bulk (as opposed to one at a time).
Thanks for your input!
© Server Fault or respective owner