May 1, 2008 at 2:19 pm
I am having an issue that I can't find a solution for.
I have a database that is replicated in our prod environment. When I try to restore that database to dev (no replication) I have issues.
I can't truncate the transaction log, I get the following:
"The log was not truncated because records at the beginning of the log are pending replication. Ensure the Log Reader Agent is running or use sp_repldone to mark transactions as distributed."
When I check sp_dboption, the database is not set as "Published"
replinfo in sysobjects is set to 0 when I check it.
I tried sp_removedreplication and get no success.
When I try to run sp_repldone, I get "The database is not published"
What gives? I need to figure out how to solve this. Any help is greatly appreciated.
Jason
May 16, 2008 at 8:20 am
Hi Jason,
On the dev box, once you have restored, republish the database as per live (i.e. same publication) then run sp_repldone, then drop the publication. You will then be able to deal with the transaction log.
Regards
Graeme
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply