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 |
|
mrtweaver
Yak Posting Veteran
67 Posts |
 Posted - 2009-11-02 : 13:26:24
|
| We have two servers, one is called Payroll and the other DataCollection. Both are running MS SQL 2005. THe Datacollection server has a view which obtains its data from the Payroll server.Occasionally we have power glitches where the connection between the two servers is disrupted. Then we end up with the problem that any other view and/or table that makes use of this view stops functioning.So my question is: Does MS SQL have some sort of store feature where it will store the last data that the query received, then if for some reason it can not establish the connection and receive new data it will resort back to the stored data, but if it does establish a connection then the most recent information retreived is stored. THanks and have a great day. |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2009-11-02 : 14:10:33
|
| Have you looked at replication? Sounds like that is what you're looking for.Be One with the OptimizerTG |
 |
|
|
|
|
|
Server feeds questions