Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2004
    Location
    Tampa
    Posts
    3

    Unanswered: Detaching a replication databse

    I am trying to detatch a database that is set up as a publisher. I have desabled the replication tasks on both the publisher and subscriber db and am still unable to detach the db. Any ideas?

    The image below is an example of the message I receive. I have tried after hours so at that time the users are 0.

    Thanks.
    Attached Thumbnails Attached Thumbnails db.gif  

  2. #2
    Join Date
    Sep 2003
    Location
    Dallas, Texas
    Posts
    311

    Re: Detaching a replication databse

    You still have active connection to the database, that's why you can't detach the database. You also need to completely uninstalled the replication. As shown on the database properties, the database still replication enabled.

  3. #3
    Join Date
    Mar 2004
    Location
    Tampa
    Posts
    3

    Re: Detaching a replication databse

    Originally posted by joejcheng
    You still have active connection to the database, that's why you can't detach the database. You also need to completely uninstalled the replication. As shown on the database properties, the database still replication enabled.
    As stated, the image just shows the current message. After hours I have 0 connections but I still receive the replication in progress message.

  4. #4
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    To confirm on replication status run sp_removedbreplication on the involved database.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •