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.
| Author |
Topic |
|
larrykl
Yak Posting Veteran
67 Posts |
 Posted - 2006-01-25 : 12:17:56
|
| I have an ASP.NET web app running on a remote server drawing data from a remote SQL Server 2000. I have a local server on which I want to intstall the web app and SQL Server 2000. I want to set up replication so that if the remote sql server goes down for any reason, the data can be drawn from the local sql server by the web app. The web app is allowing users to read and updte data so the replication type must be updating the local server as the remote server is in use. When the remote server goes down, I need to switch the web app to use the local server but once the remote server is up again, the new transactions on the local server need to be updated to the remote server.Which kind of replication do I need for this and is this doable? Right now, it seems that I'd have to do a one way type of replication and then DTS back to the remote server once it comes back up.Thanks in advance... |
|
|
mblythe
Starting Member
16 Posts |
Posted - 2006-01-27 : 12:26:03
|
| In SQL Server 2000, you could use merge replication ([url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/replsql/replintro_17zi.asp[/url]) or bidirectional transactional replication ([url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/replsql/replplan_8rhq.asp[/url]). In SQL Server 2005, you could also use peer-to-peer transactional replication ([url]http://msdn2.microsoft.com/en-us/library/ms151196.aspx[/url]). The application would need to handle failover and coordination of the replication agents. I would be happy to discuss in more detail. You can send me mail: mblythe at microsoft dot com.Michael Blythe Technical WriterSQL Server Replication - Microsoft --------------------------------------------------------------------------- This posting is provided "AS IS" with no warranties, and confers no rights. |
 |
|
|
|
|
|
Replication Questions