June 13, 2012 at 1:00 am
Hi there
Server :- SQL2008 R2
Note:- I have configured only distributor. haven't yet created Publisher nor Subscriber yet.
When i use this command to drop the distribution on the distributor instance (dist\abc), only the DB testdist is being dropped. Not all the refrence while configuring the distributor are being deleted.
Command
use master
go
alter database testdist set offline;
drop database testdist;
Things which are not being dropped (There could be more, but this is what i can see visibly)
On Distributor instance (dist\abc)
1) Right click replication
2) on the left --> click Publishers
3) Publisher = dist\abc , Distribution Database = testdist
SQl-Job which is not deleted
1) Agent history clean up: ninemsn_distribution
3) Distribution clean up: ninemsn_distribution (Disabled)
3) Reinitialize subscriptions having data validation failures
4) Replication agents checkup
5) Replication monitoring refresher for ninemsn_distribution. (Disabled)
Is there a way to restore the instance dist\abc to a state where it was before configuring distributor, by deleting the distributor and all its reference?
Cheers
Dan
June 15, 2012 at 7:50 am
Don't drop the distribution database manually. Use the GUI interface to "Disable publishing and distribution" or use the system stored procedure sp_dropdistributor.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply