Multi Building Remote Network

[jhall]

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.

 

[mmthomas]

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."