Keeping 2 SQL 2005 STD servers in sync

USGLOBAL
USGLOBAL used Ask the Experts™
on
What is the best method to keep 2 SQL 2005 standard servers in sync with each other, with or without third party software? My intention is to keep a "warm" site as a disaster recovery option. Acceptable loss would be less than 24hrs of data but no more.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Scott PletcherSenior DBA
Most Valuable Expert 2018
Top Expert 2014
Commented:
Typically you use disk-level mirroring (/replication) for a true "warm" site.

In SQL 2008 R2, you can technically use geographically dispersed clustering (more of a "hot" site).

You might have other options, depending on the amount of data and the distance between servers.

Author

Commented:
It is quite a bit of data and the connection between the sites is only a T1 so I was looking for something that could do a bit level or differential type update to the DB. The DB is large but the changes from day to day are not that big.

Author

Commented:
Anyone else have some input on this? Not afraid to go with a 3rd party software package..
11/26 Forrester Webinar: Savings for Enterprise

How can your organization benefit from savings just by replacing your legacy backup solutions with Acronis' #CyberProtection? Join Forrester's Joe Branca and Ryan Davis from Acronis live as they explain how you can too.

Senior DBA
Most Valuable Expert 2018
Top Expert 2014
Commented:
If the daily changes aren't that big, use transactional replication.

You could even use a delayed (on-demand only) replication, so that you could pick the times data was transferred, and thus avoid any heavily active periods on the main server.

Author

Commented:
ScottPletcher, any links to tutorials you think would be helpful?
Scott PletcherSenior DBA
Most Valuable Expert 2018
Top Expert 2014
Commented:
Don't know of any off the top of my head.

Books Online actually does a pretty good job of describing the steps needed to set it up, etc..

If you run into any problems, just post a followup here.

Doing an on-demand refresh of a replicated source is NOT easy, but I can help you here with that if/when you get replication set up.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial