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 |
|
sbosarge
Starting Member
3 Posts |
 Posted - 2008-09-25 : 09:54:46
|
| In general... I am looking for some ideas for this scenario.We have a SQL Server 2005 instance that is serving all of the daily business functions for all of our in house apps. We want to turn up a website to allow the public to do searching for our resources on one of the databases on the server. Obviously I don’t want web users to connect directly to the production database. I was thinking of mirroring but then a requirement was identified that will require the mirror to communicate back to the master if a web user wants to reserve a resource. I am looking for a simple solution to separate the two systems and still allow for near real-time sync between the two...Thanks for any suggestions. |
|
|
SimpleSQL
Yak Posting Veteran
85 Posts |
Posted - 2008-10-11 : 03:14:00
|
| Replication might give you what you are looking for. Log shipping will have some time delay, Mirroring, will require DB to be in restoring mode.. so not accesible. |
 |
|
|
|
|
|
website backend and replication