Re: Detachng database that's supposedly being replicated
- From: "Randall Arnold" <randall.nospam.arnold@xxxxxxxxxx>
- Date: Tue, 12 Sep 2006 16:28:47 -0500
'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
.
- References:
- Detachng database that's supposedly being replicated
- From: Randall Arnold
- Detachng database that's supposedly being replicated
- Prev by Date: Re: Log Shipping from SQL 2005 to 2000
- Next by Date: Re: Detachng database that's supposedly being replicated
- Previous by thread: Detachng database that's supposedly being replicated
- Next by thread: Re: Detachng database that's supposedly being replicated
- Index(es):
Relevant Pages
|
