Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 High Availability (2008)
 Keeping SQL EXPRESS DB in Sync

Author  Topic 

Jakdb
Starting Member

11 Posts

Posted - 2011-02-14 : 23:54:13
Hi,

We have 2 standalone applicatoins systems in same network, and we need to keep the both SQLEXPRESS DB's in sync always,please let meknow do we have any script or any procedure to do so?

Criteria
1)Both are SQLEXPRESS DB.
2)One is failover for other,

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-02-14 : 23:58:06
Take a look at replication and mirroring. If you want to step up to the HA level, you can use clustering, however you'll need to increase your SQL edition.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -