Results 1 to 3 of 3
  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
    Oct 2002
    Posts
    66
    Usually when I get these it is either residual connections from apps the end-users have not shut down, or connections from developers using EM or QA that have not been disconnected, or sometimes even a connection in EM or QA from a session on the server itself.

    Have everyone log out completely from the connecting app as well as EM and QA.

  3. #3
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Kindly do not post multiple (Duplicate) posts, refer to this http://www.dbforums.com/t989046.html link to follow.
    --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
  •