May 20, 2011 at 2:59 pm
I am wondering if anyone might be able to help me with this issue. I have server that's a subcriber for a merge replication that ran out of space. As a quick fix, i thought i could stop the sql agent, and detach the db to delete the log file then reattach and start the sql agent against afterwards. I ran into the problem that the merge agent now says i have the "emunerate" error, and when i look at the output log, it says that it cannot connect to the subscriber '\EMR\' and my 'emrhq\administrator' login failed. I'm not sure what i can do to fix this, I hope i do not have to recreate the subscription, since the snapshot is over 100gigs.
May 25, 2011 at 2:06 pm
Hi xigma,
I'm not sure deleting the log file was your best option here. A more appropriate thing to do when a subscriber's drive fills up like this is to detach the subscription database, move it to another drive that has sufficient space, and re-attach the subscription database.
I'm afraid, based on the error that you're receiving, that you may have to re-initialize your subscription.
Hope this helps.
May 25, 2011 at 3:13 pm
Hi deleting the log file was a big mistake, with a 100Gb snapshot i would expect the log at the subsciber to be twice that (gut feeling).
If you are replicating the whole Db you should have a look at replicating from backup, (never done it for merge so not sure if it would work)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply