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 |
|
uprise
Starting Member
1 Post |
 Posted - 2005-04-25 : 17:27:30
|
| I have setup a voice server locally to authenticate callers and gather information via telephone. Offsite I have a website being hosted that will both gather information and display it. All of the phone calls will be submitting their gathered information to the hosted website. I would like to accomplish two things: have an offsite backup on the voice server and in the event of an ISP failure whereby the voice system cannot contact the hosted website I would like to be able to use this offsite backup on the voice server to seamlessly take the calls.I have come up with two options:1. Whenever I submit a query to the hosted websited DB submit a simultaneous query to the voice server.2. Perform an automated nightly backup of the hosted websites DB to the voice server. I don't know how to do this but it would be sufficient.This will be a very low volume website. Does anyone have any ideas on what would be my best course of action?Thanks,Mike D. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-04-25 : 17:32:18
|
| A two-phase commit is an option if you can afford the performance of having to commit the transaction to two servers. If you can't, which we can't, then I'd implement log shipping. We have transaction log backups that run every 15 minutes, get copied to the secondary server at our disaster recovery site, then restored. We do this through SQL Server Enterprise Edition's log shipping, however you can create custom stored procedures to do the same if Ent. Edition isn't an option. Some people have used transactional replication as a solution as well, although it isn't recommended as a DR option.Tara |
 |
|
|
|
|
|
System Setup Advice