Script to mirror MS SQL Server databases between 2 servers
- by David W
Hi
I have about 200 sites each of which have 2 servers running MSSQL (2k5 at some sites, 2k8 at others)
One server is production and the other is primarily there as a backup.
We're rebuilding all of these servers this year and as part of that we will have to set up mirroring for ... a lot ... of databases.
Some of these sites have 45 databases…