<div>
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
</div>


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

<div>
Hi I manage to bring the db online:<br />
<br />
remove the missing files from sysaltfiles<br />
run dbcc dbrecover<br />
and run sp_replicationdboption to release the database from be a publisher,<br />
I will still giving away ur point becaue the link showing me some hint how to work with remove the replication.
</div>


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.

<div>
<div class="content wysiwyg-content">
HI,<br />
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 &nbsp;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?
</div>
</div>


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?

delete db in suspect mode which has replication configured

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.