I had replication job in one database. Since I need to detach the database
and move it somewhere else, I deleted all publications. However when I tried
to detach the db, the error message says that the database cannot be detached
because it is replicated. I updated the statistics of both that database and
distribution database. However the error remains. Please advice.
Thanks,
Charts
Try using sp_dboption to set 'published' and 'merge publish' to false.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||Great ! It works. Thanks so much.
"Paul Ibison" wrote:
> Try using sp_dboption to set 'published' and 'merge publish' to false.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
>
>
Sunday, March 25, 2012
Cannot detach the database for previous publications
Labels:
database,
databaseand,
deleted,
detach,
job,
microsoft,
mysql,
oracle,
previous,
publications,
replication,
server,
sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment