Home > Archive > Microsoft SQL Server forum > February 2006 > Synchronize data between 2 instances of SQL Server Express?









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Synchronize data between 2 instances of SQL Server Express?
holysmokes99@hotmail.com

2006-02-20, 8:24 pm

I am building an application with a SQL Server 2005 Express backend. I
would like to create a secondary instance the database on another
server that will serve as a fail-over in case the primary server goes
down (there is only the Express version of SQL Server in this picture).

I see that replication in SQL Server Express only works as a
subscriber and not a publisher. Can anyone suggest a method that I can
ensure that both instances of the database propagate data between them
when they are both available? The app is written in VB.Net.

Thx,
Marcus

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com