Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

DB thinks it's replicated Expand / Collapse
Posted Friday, January 14, 2011 3:39 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, February 4, 2011 10:05 AM
Points: 49, Visits: 70
svr1: primary svr, transactional repl setup, distribution db and publisher exist, one db.

svr2: reporting svr, used only as subscriber to one db.

All is well with how replication is setup and it works fine. Now here is the problem:

Made a copy of the db from svr1 and restore it to svr2. It created a new publisher for this restored db which I did not want. I scrubbed all data from the system tables under this newly restored db and was able to delete the newly created publisher. Stopped all repl jobs on svr1 and stopped and restarted sql services. When I tried to detach this db it says that its being used for replication.

What other areas do I need to look to resolve this issue?
Post #1048248
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse