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 |
|
Brenda
Starting Member
1 Post |
 Posted - 2005-07-23 : 12:24:45
|
| Hello, I'm using a database on a server and another one on a server in another city. Both are production databases for retail stores. I need to see here every day, the sales data from the other store.Normally, the merge replication works just fine, but a month ago, I had a communication problem that lasted for 3 weeks. When the problem was fixed, the replication began to work normally again, but replicated the data of the last 2 weeks. It didn´t replicated the information from the first week the communication was down. Does anyone know how can I get this week of data?????Thanks for your help. |
|
|
mblythe
Starting Member
16 Posts |
Posted - 2005-07-25 : 18:50:08
|
| You could do a "dummy update" of the rows that were not replicated (i.e. SET YourCol = YourCol), so that merge will send the "updated" row to the Subscriber. If you can easily determine which rows were older than two weeks, just restrict the update to these rows; if not, you will have to update all rows.Michael Blythe Technical Writer SQL Server Replication-----This posting is provided "AS IS" with no warranties, and confers no rights. |
 |
|
|
|
|
|
Problem with merge replication