Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 525
  • Last Modified:

delete replication???

Hi,
I'm trying to delete replication, distribution database, but sql prompt me error cannot drop the database distribution because is being in use for replication, but I has disabled all replication,,,,,
0
motioneye
Asked:
motioneye
1 Solution
 
chhapia_chintakCommented:
Execute following commands after changing your database name.


exec sp_removedbreplication 'db_name'
go
exec sp_dboption 'db_name','published',false
go
exec sp_dboption 'db_name','merge publish',false
go

Hope this helps.
0
 
motioneyeAuthor Commented:
Hi,
I manage to delete the distribution db after refresh the db, but now it giving error while I'm trying with creating a distrbution db it giving me error as invalid path, this is actually 2nd instance of sql server \\LLL0039\SQL_TEST

\\LLL0039\SQL_TEST\f$\MSSQL$SQL_TEST\ReplData
0
 
csachdevaCommented:
Hello,

Check Sysobjects of the database which is going fro replication then query for values having replinfo >0 and update those tables by zero and then check it.

second way is to re enable replication process and then try to disable it.

Hope that will sort out your query.

regards,
Chetan Sachdeva
0
 
motioneyeAuthor Commented:
Hi,
I manage to solve the problme,
there is actually the F drive was not assigned as F$ and never been shared last time, it's now Ok after I let the drive to be share and assign with F$
0
 
NetminderCommented:
Closed, 500 points refunded.
Netminder
Site Admin
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now