replicating databases in two remote offices

how can i a keep 2 databases a sychronized as possible in two different offices? both databases run off websites with a different extentension. (.cc and .net). i need both updated as much as possible incase one of the sited goes down. im a new network administrator and really do not know much about databases so please explain as simply as possible. i have vpn setup on both sites if that helps. thanks
andreb2005Asked:
Who is Participating?
 
arbertConnect With a Mentor Commented:
It's when you perform a log backup of your database and copy (ship) it to another server and restore it.

It's built in to SQL Enterprise edition via a maintenance plan.  However, you can manually set it up on any version (it works really slick--we use it on several of our disaster recovery plans for clients).  Here is a brief overview and how you can config it:

http://www.sql-server-performance.com/sql_server_log_shipping.asp

Brett
0
 
arbertCommented:
How "up to date" do you want to keep the sites?

There are several forms of replication you could use--depends on your requirements.  Personally, I would direct both of your websites to the same database, and , on the backup, setup logshipping to another server.
0
 
andreb2005Author Commented:
well i would like to keep it as p to dat as possible but at the very minimum once a day. the boss does not want to use the same database, that is the point of having it in 2 different location incase one fails.
0
 
arbertCommented:
"the boss does not want to use the same database, that is the point of having it in 2 different location incase one fails."

Did you read my post?  The websites hit one central location.  However, you have another SQL hosted on the backend that you logship or replicate to.  In the event of a failover, you bring the other server online--no code changes.  The way you have it setup now, you either change code to point to another database server when the site fails, or you change DNS (which could actually take a couple of days to populate everywhere).
0
 
andreb2005Author Commented:
what is logshipping
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.