I had this error in one of the databases and I was trying different possible steps to fix it.
I tried to take a transactional log back up - no luck
I tried to change the recovery model to simple - no luck
The database does not have replication but it does have CDC enabled. So I tried to disable the CDC I got another error related to metadata
I tried to change the db owner to sa - no luck still error
Then the following helped me to get rid of the error that was saying replication
EXEC sp_repldone @xactid = NULL, @xact_sgno = NULL, @numtrans = 0, @time = 0, @reset = 1;
I tried to change the db owner to sa after running the above - success
I tried to disable the CDC - success
I expanded the log file - success
This is how I was able to resolve the issue.
No comments:
Post a Comment