September 1, 2011 at 10:13 am
We finally get them to purge their data. The issue you had on the weekend of the 6th was that they put in a -1 in the parameter, then finally realized they made a mistake and put a value in the parameter on the 4th. Then the program wouldn’t run because of conflicts, when it finally ran, I was able to shrink the files. That was the 8th ,.
Then we had the wandering 50GB, and for some reason their BO reports stopped working. On the 10th according to the logs – replication started throwing errors.
I get asked about it on the 16th, I do the check of the replication monitor and it says everything is green .
When they say they have an issue, I reinitialized their publication and made sure all the active agent jobs are running (3 were not because of login id), they don’t get back to me till the next day.
On the 18th I finally reached a point where I shut down everything and restarted the replication process using the two sql queries
That opened up the distribution database, which had reached 46GB, with records that the subscriptions were not picking up. That in turn grew the transaction log which created a space issue on the E drive where we keep the distribution database. Once the 46 Gb of transactions was processed, I was able to shrink the log and the database to their normal size.
I ran a query and there is a lack of data between 8.10 and 8.19.2011. The system is supposed to keep itself in-sync, but apparently it has processing delays.
the replication monitor is useless as far as determining if there is an error. Other than a gross problem, such as the agent being stopped, it shows nothing.
So the only solution is to stop the process and then restart it.
September 1, 2011 at 10:52 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://qa.sqlservercentral.com/Forums/Topic1168783-391-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply