What is the best way to replicate SQL 2008 DBs to a failover site?

55 pts.
Tags:
Failover
SQL Server
SQL Server 2008
SQL Server database
SQL Server replication
We are looking to replicate our SQL 2008 databases to a hot failover site.  We can't use DB mirroring due to the number of databases we have.  Has anyone replicated databases to a hot site using a replication solution and what was your experience.

Software/Hardware used:
MS SQL Server 2008

Answer Wiki

Thanks. We'll let you know when a new response is added.

There are a lot of questions which need answering before you can decide on a solution.

1. How much data are you willing to loose when a failover occurs?
2. What sort of downtime is acceptable when you need to fail over?
3. What sort of window is acceptable when you need to fail back?
4. How much bandwidth to you have between sites?
5. How much data change to you have on an hourly basis? Per Minute?

There are probably more questions which need to be asked but these will get you started. Without knowing these answers you can’t pick the correct solution.

Discuss This Question: 5  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • adelgadom
    From my point of view, I think one way to go should be logshipping. It's on Standard version as well, not as on SQL2000 that was on Enterprise ediitons (since 2005 it's included on Standard versions). It's very easy to set up, and easy to administer. Thansk,
    30 pointsBadges:
    report
  • Subhendu Sen
    In Answer Wiki:, I have already provided the easiest way at this stage elaborately ! And provided more details for current scenario with more than one solution.
    28,600 pointsBadges:
    report
  • Subhendu Sen
    n Answer Wiki:, I have already provided the easiest way (i.e. logshipping) at this stage elaborately ! And provided more details for current scenario with more than one solution.
    28,600 pointsBadges:
    report
  • RicardoBach
    I suggest DoubleTake, when installed at our site to repicate a SQL 2005 database, it ran unattended and perfectly for about three years until we shut it down and movewd the ERP to the cloud.
    10 pointsBadges:
    report
  • Subhendu Sen
    @DaveMPA, Now go thru the above questions as Mrdenny asked against ur query ! As per my experience, "LOGSHIPPING" is the best way as per ur current scenario. and I provided full description in my earlier writings.... in Answer Wiki
    28,600 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following