Desperate......thinks replication is still there?

• lkennedy76

  SSChampion

  Points: 13683

  More actions

  September 1, 2009 at 2:05 pm

  #214072

  I dropped the distributor database using

  sp_dropdbreplication and

  Use master

  Alter DATABASE distribution SET OFFLINE

  DROP Database distribution

  now the distribution db is gone but it still thinks that it is still their? I need to get rid of all replication and recreate the distribution db and start clean and when I try to go through the GUI it tells me it cannot disable because the datebase no l;onger exsits in master sys.databases. Does any one have any idea how I can get this done?

  MCSE SQL Server 2012\2014\2016

• lkennedy76

  SSChampion

  Points: 13683

  More actions

  September 1, 2009 at 2:54 pm

  #1047843

  GOT IT.

  MCSE SQL Server 2012\2014\2016

• lkennedy76

  SSChampion

  Points: 13683

  More actions

  September 1, 2009 at 2:56 pm

  #1047845

  GOT IT. I ran

  sp_dropsubscriber 'servername', @Ignore_distributor =1

  then

  sp_dropdistpublisher 'servername', @Ignore_distributor =1

  then

  use [master]

  exec sp_dropdistributor @no_checks = 1

  GO

  Then I was able to recreate the distributor DB

  thanks! 😀

  MCSE SQL Server 2012\2014\2016

• systems5

  Valued Member

  Points: 62

  More actions

  September 16, 2011 at 4:00 pm

  #1382813

  How could you do it?

  I could drop the database Distribution

  But, i can't execute succesfully the stored procedure

  exec sp_dropdistpublisher @@serverName, @Ignore_distributor =1

  Msg 21033, Level 16, State 1, Procedure sp_dropdistpublisher, Line 159

  Cannot drop server 'BZGYDB02\DBGYE' as Distribution Publisher because there are databases enabled for replication on that server.

  use [master]

  exec sp_dropdistributor @no_checks = 1

  I got the next error message:

  Msg 20029, Level 16, State 1, Procedure sp_MSpublishdb, Line 57

  The Distributor has not been installed correctly. Could not disable database for publishing.

• systems5

  Valued Member

  Points: 62

  More actions

  September 16, 2011 at 4:01 pm

  #1382814

  How could you do it?

  I could drop the database Distribution

  But, i can't execute succesfully the stored procedure

  exec sp_dropdistpublisher @@serverName, @Ignore_distributor =1

  Msg 21033, Level 16, State 1, Procedure sp_dropdistpublisher, Line 159

  Cannot drop server 'BZGYDB02\DBGYE' as Distribution Publisher because there are databases enabled for replication on that server.

  use [master]

  exec sp_dropdistributor @no_checks = 1

  I got the next error message:

  Msg 20029, Level 16, State 1, Procedure sp_MSpublishdb, Line 57

  The Distributor has not been installed correctly. Could not disable database for publishing.

  Please, i don't know what to do