June 18, 2009 at 5:18 pm
Hello, we are using SQL Server 2005 EE SP3 and are thinking about an option where we have 1 DR (Disaster Recovery) SQL box to host 3 PROD servers whenever DR strikes. Having a 1:1 ratio would be nice, but is only a remote chance due to budget constraints.
The capacity of the DR is exactly the same of the 3 PROD with the exception of the disk space, where it can host all combined volume of the 3 PROD dbs. Obviously, the performance will be a big hit, but management thought process is at least it gets us up and running.
Wonder what other gotchas do we need to be aware for a 1:M DR SQL setup compares to a 1:1 DR setup? Below are the obvious one:
* Consolidations of logins, jobs, operators, etc. -- we probably have to designate 1 master for msdb, logins, alerts among the 3 and manually scripts in the other 2 set daily?
Thanks.
June 22, 2009 at 3:36 pm
As you are running Enterprise, why don't you have three instances and log ship to each? Works well for us!
Steve.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply