Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

DOCUMENT Expand / Collapse
Author
Message
Posted Monday, August 30, 2010 4:40 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, July 1, 2011 5:44 AM
Points: 1, Visits: 31
We currently have got the necessary servers ready to build a cold standy-by DR for our current production environment. The DR SQL database is expected to be synched once in a day with the production database. Hence we wanted to check with you if you have any standard practices / documents that you could share with us to understand:

1. The steps to be taken / be prepared for when we need to bring the DR site up when have a catastrophic failure in the current production environment

2. The steps to be taken / be prepared for when we need to promote the failed production environment back to production by pushing across the data held by the DR environment database while the DR site was promoted to temp production when the primary site was down.


Please mail me : abhishek_dwivedi03@infosys.com TIA
Post #977226
Posted Monday, August 30, 2010 5:23 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 21, 2014 2:56 AM
Points: 2,603, Visits: 2,061
Actually it depends, what exactly your customers requirement is.....
because from budget to latency and dataloss it depends.

But I guess budget is low and latency will be fine from your description. You can consider Snapshot replication if the database size is very small or you can think of Log Shipping, mirroring etc.

HTH


---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Post #977244
Posted Monday, August 30, 2010 8:54 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 11:19 AM
Points: 1,194, Visits: 2,215
Hi Srinath,

As you need once in a day day referesh, it would be better to use Log Shipping which a very robust and proven solution for the DR.

If you need realtime data synchronization, use Database Mirroring.

In both the cases you can do the Manual/Automatic Failover (DB Mirroring) to switch back to the actual prod server from the DR server.

http://www.sql-server-performance.com/articles/clustering/log_shipping_70_p1.aspx

http://www.sql-server-performance.com/articles/clustering/mirroring_2005_p1.aspx

Thank You,

Best Regards,
SQL Buddy.
Post #977379
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse