Detaching replicated database

Hello there
I have database that i marked it before as publisher. Since then it showed
with hand near to it. And then i can't detach it.
I remove the publisher and it didn't help
What should i do for detach it now?
any help would be useful
Whell Paul
How can i get this book?
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:27bd01c4af70$fd679b00$a301280a@.phx.gbl...
> I'm not too sure what stage the system is in - you
> mention you have removed the publisher - does this mean
> that you have disabled publishing, or removed the
> publication. I think it must be the latter. In this case
> try resetting the replication flags on the database in
> question. EG if it was Pubs:
> exec sp_dboption 'pubs','published',false
> exec sp_dboption 'pubs','merge publish',false
> After that you should be able to detack.
> HTH,
> Paul Ibison (SQL MVP)
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
|||Oded,
I've been lucky enough to have a sort of advanced
preview, but to register for it when it comes out
publically (imminently AFAIK) have a look at this
address: http://www.nwsu.com/0974973602reg.html.
Apparently it will eventually be available on Amazon
etc. - Hilary will be able to give you more info (if he
doesn't see this thread then post a separate one in this
newsgroup FAO Hilary Cotter).
Regards,
Paul Ibison (SQL Server MVP)

detach 6.5 compatible database in studio - HOW?

I've got two databases showing in the studio tree, but they are marked 6.5 compatible and cannot be expanded. Worse, there is no way (apparently) in the menu of either database to remove, delete or detach them.

How can I get these out of the system?

Thanks in advance.

randyv

What about using the TSQL statement for dropping / detaching the databases ? (DROP DATABASE / sp_detach)

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

No, that doesn't work because it is grayed out... It finally dawned on me that since I could not take any action directly on the database due to compatibility problems, but that the database was from 2000, there was no reason the level could not be increased.

To make sure I had no problem with the application, this is what I did. I backed up the database on the 2000 server, then restored it as a different database. Then I changed the compatibility level on that restored database to 80.

Next I backed that databased up and copied the .bak file to the other server running 2005.

Then I restored that .bak file as the existing 6.5 level database with a restore over existing database flag turned on.

Presto ! Problem solved. It is taking the long way around the problem, but there is no other option open, apparently.

|||

Try to run this transact sql script against your database:

USE databaseName
GO
EXECUTE sp_dbcmptlevel databaseName , 90
GO
EXEC sp_updatestats
GO

detach 6.5 compatible database in studio - HOW?

I've got two databases showing in the studio tree, but they are marked 6.5 compatible and cannot be expanded. Worse, there is no way (apparently) in the menu of either database to remove, delete or detach them.

How can I get these out of the system?

Thanks in advance.

randyv

What about using the TSQL statement for dropping / detaching the databases ? (DROP DATABASE / sp_detach)

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

No, that doesn't work because it is grayed out... It finally dawned on me that since I could not take any action directly on the database due to compatibility problems, but that the database was from 2000, there was no reason the level could not be increased.

To make sure I had no problem with the application, this is what I did. I backed up the database on the 2000 server, then restored it as a different database. Then I changed the compatibility level on that restored database to 80.

Next I backed that databased up and copied the .bak file to the other server running 2005.

Then I restored that .bak file as the existing 6.5 level database with a restore over existing database flag turned on.

Presto ! Problem solved. It is taking the long way around the problem, but there is no other option open, apparently.

|||

Try to run this transact sql script against your database:

USE databaseName
GO
EXECUTE sp_dbcmptlevel databaseName , 90
GO
EXEC sp_updatestats
GO

detach 6.5 compatible database in studio - HOW?

I've got two databases showing in the studio tree, but they are marked 6.5 compatible and cannot be expanded. Worse, there is no way (apparently) in the menu of either database to remove, delete or detach them.

How can I get these out of the system?

Thanks in advance.

randyv

What about using the TSQL statement for dropping / detaching the databases ? (DROP DATABASE / sp_detach)

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

No, that doesn't work because it is grayed out... It finally dawned on me that since I could not take any action directly on the database due to compatibility problems, but that the database was from 2000, there was no reason the level could not be increased.

To make sure I had no problem with the application, this is what I did. I backed up the database on the 2000 server, then restored it as a different database. Then I changed the compatibility level on that restored database to 80.

Next I backed that databased up and copied the .bak file to the other server running 2005.

Then I restored that .bak file as the existing 6.5 level database with a restore over existing database flag turned on.

Presto ! Problem solved. It is taking the long way around the problem, but there is no other option open, apparently.

|||

Try to run this transact sql script against your database:

USE databaseName
GO
EXECUTE sp_dbcmptlevel databaseName , 90
GO
EXEC sp_updatestats
GO