Re: Detachng database that's supposedly being replicated
- From: "Randall Arnold" <randall.nospam.arnold@xxxxxxxxxx>
- Date: Tue, 12 Sep 2006 17:05:03 -0500
I am familiar with BOL, but just didn't find what I was looking for in it
(as usual). I have a general beef with BOL because it usually conveys info
at too high a level to help me (ie, "you need to do such-and-such but we're
not gonna tell you how"). Also, searching on terms specific to the problem
as it's reported doesn't always turn up relevant hits. However, I did find
this in a google search:
USE master
GO
EXECUTE sp_dboption 'ASOQA', 'published', 'false'
GO
That turned it off. Unfortunately, enterprise manager *still* thinks the
database is being replicated even though I see no sign that it actually is.
I tried simply exporting all tables to another database but that process
locks up. I guess I'll just keep chipping away and figure something out
sooner or later...
Randall Arnold
"John T" <JohnT@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:CDE92BA0-9F96-402E-93D0-A3FB4A0E9600@xxxxxxxxxxxxxxxx
Are you familiar with Sql Server Books Online? Judging from your
follow-up
question, I suspect you may be missing a lot of helpful info. Check it
out.
Its all there.
"Randall Arnold" wrote:
'Published' is set to ON, but 'Merge Published' seems to be a nonexistant
property.
So if I need to set 'Published' to Off, how do I go about doing that? I
thought I'd do it through enterprise manager but don't see a means...
Thanks,
Randall Arnold
"John T" <JohnT@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:61B20AB8-D704-4E72-B5CD-2E78E9A9C123@xxxxxxxxxxxxxxxx
Actually, as I think about it,
exec sp_dboption 'dbname', 'published'
exec sp_dboption 'dbname', 'merge published'
If any of these are true, you might want to try explicitly setting them
to
'false'
"Randall Arnold" wrote:
Greetings all.
I have a SQL Server 2000 database that I need to temporarily detach
for a
copy to a new server. However, the task cannot be executed because SS
reports that the database is in process of being replicated. This
should
not be the case: all agents have been disabled and i show no activity
at
all
against the database when I look. So what's going on? And I do I
break
through this? I can only find high-level info that's been no help.
Thanks,
Randall Arnold
.
- Follow-Ups:
- References:
- Detachng database that's supposedly being replicated
- From: Randall Arnold
- Re: Detachng database that's supposedly being replicated
- From: Randall Arnold
- Detachng database that's supposedly being replicated
- Prev by Date: Re: Detachng database that's supposedly being replicated
- Next by Date: Re: Detachng database that's supposedly being replicated
- Previous by thread: Re: Detachng database that's supposedly being replicated
- Next by thread: Re: Detachng database that's supposedly being replicated
- Index(es):
Relevant Pages
|
