I can't delete Distributor. The system shoew message error "Could not drop the Distributor 'Dis_name'. This Distributor has associated distribution database"
5
-
2have you checked the official doc? learn.microsoft.com/en-us/sql/relational-databases/replication/…– MBuschiCommented Jul 1 at 8:20
-
Yes, I tried to follow the documents it but can't delete.– WP JLKCommented Jul 2 at 2:19
-
and the output of this sp sp_helpdistpublisher is?– MBuschiCommented Jul 2 at 7:31
-
I has run EXEC sp_helpdistpublisher , the system show output as follows : security_mode = 0 active = 1 trusted = 0 thirdpatry_flag = 0 storage_connection_string = NULL– WP JLKCommented Jul 2 at 9:36
-
If you look at the distribution_db column you fill find what is the name of distribution db that is active and has do be removed before dropping the distributor.– MBuschiCommented Jul 2 at 11:21
Add a comment
|