• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 192
  • Last Modified:

delete db in suspect mode which has replication configured

HI,
My db is no in suspect mode due to one of the file missing, someone has deleted the file because this db has noit been in production for 3 mth ( services stop), and now I want to drop the database permanently but it wont allow me to  do so because it exist for replication. I had try also to drop the replication but due to db in suspect mode I can't do that.. what are the option available for me to delete the db?
0
motioneye
Asked:
motioneye
  • 2
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
0
 
motioneyeAuthor Commented:
But how do I access the db since it now in suspect mode?? without getting access to the publication db I dont think I can drop the replication
0
 
motioneyeAuthor Commented:
Hi I manage to bring the db online:

remove the missing files from sysaltfiles
run dbcc dbrecover
and run sp_replicationdboption to release the database from be a publisher,
I will still giving away ur point becaue the link showing me some hint how to work with remove the replication.
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

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