question

zillabaug avatar image
zillabaug asked

How to fix deleted replicated record

I accidentally deleted a record in a table that is replicated from another table in a database hosted on a remote server.I know replication is going to break at some point in time when it tries to update changes made on the publication over to the subscriber. I need to fix this immediately before that happens. Does anyone know how to fix this?
sqlreplication
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Can you access the publication ? If yes, try an update ( on publication) for that row like Update dbo.XXX SET column1 = column1 WHERE rowID = yourID.
0 Likes 0 ·

1 Answer

· Write an Answer
zillabaug avatar image
zillabaug answered
I figured it out. Thanks guys!
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.