November 12, 2013 at 10:04 am
Hi
I have restored one of my databases and as a result I have to re create replication publications and subscriptions. I had them already pre scripted as i knew this would need doing.
Now after I run all the scripts to recreate them, I get an error saying '-The log scan number (76717:135864:4) passed to log scan in database X is not valid. This error may indicate data corruption or that the log file does not match the data file. If this error occurred during replication re create the publication. Otherwise restore from backup....
I fixed this previoulsy by dropping everything and recreating the distributor and the publisher and then re-running my scripts to set it all up again.
Is there a quicker fix here ? I feel it something to do with the log file not matching and not any data corruption. Is there something i can run to sync the log files if that is the issue ?
Other wise its back to the start !!
November 15, 2013 at 7:50 am
I ran into this situation before, here are the step I used:
RESTORE A PUBLISHER DATABASE (T-log Replication)
1. STOP THE LOG READER AGENT FROM THE REPLICATION MONITOR
2. RESTORE THE PUBLISHER DATABASE BACK TO THE POINT IN TIME YOU WISH TO RESTORE TO
3. RUN "sp_replrestart"
4. START THE LOG READER AGENT FROM THE REPLICATION MONITOR
5. RE-INITIALIZE THE THE SUBSCRIPTION FROM THE REPLICATION MONITOR
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply