tomes12 (2/21/2013)
Hi, thanks for the quick response.Of course, I see what you're saying.
Yes, mirroring/log shipping is all an option and under consideration.
That still asks the question how would it work if I enable it for 500 databases?
How much additional load would it create? How much bandwidth would it take up?
I've done tons of DR solutions in the past, but never on this scale, and I can't just start ramping up log shipping for the databases one by one just to see "how will it go".
Is there maybe a way I could test/estimate/calculate this sort of thing before I actually go and implement it for 500 dbs.
Any ideas/thoughts. Thanks
To be honest I've never been exposed to a SQL instance with so many databases so this is new to me too.
Let's see what the other experts have to say. I'm intrigued!
---------------------------------------------------------
It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]
Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn