Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Distributor database dropped

Author  Topic 

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2011-06-16 : 14:06:28
Hi Team,
one of my team member had deleted the mdf and ldf files of distribution database while file movement to other drives. now while i'm trying to disable publisher, it is not allowing.

can you please guide me how can i disable forcefully the distribution?

Thanks in advance.

Arnav
Even you learn 1%, Learn it with 100% confidence.

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2011-06-16 : 15:38:30
sp_removedbreplication

If that fails, disable the SQL Agent jobs involved.

You do have a backup of distribution, right?


Edit: have a look at this: http://msdn.microsoft.com/en-us/library/ms147921.aspx
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-06-16 : 16:18:38
Also see this: http://weblogs.sqlteam.com/tarad/archive/2009/09/02/How-to-remove-a-SQL-Server-distribution-database-if-other.aspx

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -