delete db in suspect mode which has replication configured

Posted on 2007-08-10
Last Modified: 2008-02-01
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?
Question by:motioneye
    LVL 142

    Accepted Solution


    Author Comment

    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

    Author Comment

    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.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Performance is the key factor for any successful data integration project, knowing the type of transformation that you’re using is the first step on optimizing the SSIS flow performance, by utilizing the correct transformation or the design alternat…
    Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
    Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

    733 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now