November 16, 2004 at 8:30 pm
Hi,
I have transactional replication set up between servers hw1 and hw2 so that distributor database is on hw1.
When we shut down server hw1, VB application accesses database on server hw2. The application first adds new records using INSERT statement. Records have only required fields populated while other are nulls. Application then updates values for columns with NULLS in records just added to database using UPDATE statement.
When server hw1 starts up, replication process removes updates made using UPDATE statements from server hw2 leaving records added while hw1 was down with null values in several columns.
If database updates are made on hw1 then hw2 receives records correctly replicated. There are no NULLS in the records.
Would be tankfull for any hint on what is wrong with set up of replication process?
Thanks,
Branko
November 17, 2004 at 12:12 am
Addition to description of the problem.
The replication process overwrites values created by UPDATE statements with NULLS even during normal replication proces if database updates are done on stand-by server hw2. When data is generated on primary server hw1 the data is correctly replicated.
Thanks for any suggestion.
Branko.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply