?
Solved

replicating databases in two remote offices

Posted on 2005-04-30
5
Medium Priority
?
238 Views
Last Modified: 2010-03-19
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
0
Comment
Question by:andreb2005
  • 3
  • 2
5 Comments
 
LVL 34

Expert Comment

by:arbert
ID: 13903141
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
 

Author Comment

by:andreb2005
ID: 13904514
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
 
LVL 34

Expert Comment

by:arbert
ID: 13904532
"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
 

Author Comment

by:andreb2005
ID: 13905906
what is logshipping
0
 
LVL 34

Accepted Solution

by:
arbert earned 1500 total points
ID: 13906127
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

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Suggested Courses

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question