September 23, 2014 at 4:32 pm
I wanted to see what suggestions you might have for Disaster Recovery Options based on the following criteria.
--Currently running SQL 2012 standard edition
--We have 18000 databases (same schema across databases)- majority of databases are less than 2gb-- across 64 instances approximately
--Recovery needs to happen within 1 hour (Not sure that this is realistic
-- We are building a new data center and building dr from the ground up.
What I have looked into is:
1. Transactional Replication: Too Much Data Not viable
2. AlwaysOn Availability Groups (Need enterprise) Again too many databases and would have to upgrade all instances
3. Log Shipping is a viable option and the only one I can come up with that would work right now. Might be a management nightmare but with this many databases probably all options with be a nightmare.
Is there anything else that you can think of that I should look into?
Thanks in advance for any help provided.
September 23, 2014 at 11:22 pm
Hi There,
If your infrastucture is virtual you can look at something like SRM (Site Recovery Manager)
to replicate to DR. We use this method at my current employer
Corinne
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply