SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


DOCUMENT


DOCUMENT

Author
Message
srinath.nuka
srinath.nuka
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
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 :-D
free_mascot
free_mascot
SSCertifiable
SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)

Group: General Forum Members
Points: 7541 Visits: 2250
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."
sqlbuddy123
sqlbuddy123
SSCertifiable
SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)

Group: General Forum Members
Points: 6212 Visits: 2243
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search