May 17, 2005 at 2:43 am
Hello Experts,
What we are looking for is a solution where we can have two databases supporting to run our website on one server so that in the unlikely event that one of the database servers is not working, the site can start working on server 2 and is never out of business. I know how I can check the connection state in ASP and can connect to server 2 in case server 1 is not working but the issue is that how do I synchronize both the servers and keep all the data up to date.
Any help would be greatly appreciated.
May 17, 2005 at 4:40 am
You can implement Log shipping or Replication for Upto date Database. Pls. Check SQL Server Book Online for Log shipping and Replication.
May 17, 2005 at 3:13 pm
It also depends if you are hosting a catalog server (static data) or other database that are always changing.
If static, you could refresh your database so that it is always in synch with server 1 or log shipping or other mechanism such as replication.
mom
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply