Post reply

Sync 4 express servers

  • April 11, 2011 at 5:14 am

    #249274

    Hello.

    I have 4 SQL express servers in 2 networks (2 SQL's in each network).

    How can I sync them?

    Can I only sync each pair?

    I may be short of details here... what else need to know?

    Any info/help will be great.

    Thanks.

  • April 11, 2011 at 6:35 am

    #1309773

    it depends on what you mean by "sync" and also the allowed latency of the data.

    if you mean combine changes from each server into one master database, that's a lot more involved;

    If you mean you have one server that has a database you want copied/propagated elsewhere(you said to three or four other servers),

    you can do a backup, copy the backup to the other servers, and restore them there.

    you can also use replication, which could push changes from the source server out to the other servers, assuming the servers can get to each other over a network.

    Another option is log shipping , where you restore the database once on each server, and then your logs are shipped from the source server out to the other servers, where they can be restored to sync changes that occurred on the source server.

    If you can provide some more details, we might be able to point you to a more specific solution.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply