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.
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.ArnavEven you learn 1%, Learn it with 100% confidence. |
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-06-16 : 15:38:30
|
sp_removedbreplicationIf 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 |
 |
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|