Jump to content
Forum²

Recommended Posts

Posted

Hello,

 

I was wondering if someone can tell me what a particular type of network is called so I can research into setting it up.

 

What I want to do is connect two buildings to a database (located in one building).

 

I want the remote building to save a "ghost" database of sorts so that in case of network interuption it is not completely unable to function with the database. Then when it manages to reconnect over the internet it will update any changes it may have had in the database.

 

Is this possible and if so is there a name for it so I can learn about setting it up?

 

Many thanks.

Posted

If you need automatic failing over to the backup, then search for "failover clustering" or "SQL server failover clustering."

 

If you are going to manually fail over or can't afford clustering, then search for "SQL log shipping."

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...