DR for server SQL2008 R2

Last Post 27 Jun 2012 05:37 AM by rm. 5 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
loverr5
New Member
New Member

--
26 Jun 2012 12:25 AM
Good day..i just want to ask for any suggestion on what is the best practice for a DR for our SQL2008 R2 server with practically 120 databases. Is database mirroring OK? Need answer badly...huhuhu...thanks in advance
rm
New Member
New Member

--
26 Jun 2012 05:22 AM
How many servers here? You are looking for trouble to mirror 120 dbs on single instance.
gunneyk
New Member
New Member

--
26 Jun 2012 05:47 AM
I agree that mirroring with that many dbs is not a great idea. Do you have a way to do SAN to SAN replication? That may be a better way to deal with so many dbs in a DR situation.
loverr5
New Member
New Member

--
26 Jun 2012 05:57 PM
RM,

We have just 1 server for our 120++ dbs...is it not possible to mirror these dbs? Is there an ideal number of dbs to mirror?
loverr5
New Member
New Member

--
26 Jun 2012 06:08 PM
Gunneyk,

I have no knowledge on SAN--but thanks to the idea..We might discuss that with our team...
rm
New Member
New Member

--
27 Jun 2012 05:37 AM
Mirroring how many dbs on an instance really depends on type and rate of transactions, we have hard time to mirror 40 dbs in HS mode on server with 16 cpus and 128gb memory.


Acceptable Use Policy
---