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 2005 Forums
 High Availability (2005)
 Synchronizing web db w prod db real time

Author  Topic 

tpanek
Starting Member

2 Posts

Posted - 2006-10-30 : 10:08:54
We are moving our website to be hosted offsite. Our internal applications use same database as website. We plan on maintaining two versions of same data, one on a remote server (for the website) and the other hosted locally available to all internal applications. The two databases need to be synchronized real-time. We are using SQL server 2000 and are researching mirroring software and replication capabilities of SQL server.
Does anyone have any recommendations?



spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2006-10-30 : 12:01:51
log shipping is out of the question for you?
http://support.microsoft.com/kb/314515

also check out Split-Mirror Backup and Restore
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/spltmirr.mspx



Go with the flow & have fun! Else fight the flow
blog thingie: http://weblogs.sqlteam.com/mladenp
Go to Top of Page
   

- Advertisement -