Groups | Blog | Home
all groups > sql server (microsoft) > february 2006 >

sql server (microsoft) : Option to take database offline is missing


Admin Matt
2/22/2006 12:08:10 PM
We are running SQL Server 2000. I can take all databases offline in SQL
Server Enterprise Manager except once. The option is not even there on
the menu for that database. Does anyone know why this would happen?
Admin Matt
2/22/2006 12:24:37 PM
I tried to detach instead and it said I can't detach while the database
is being replicated. From what I can tell though that actually isn't
the case. Also I have tried this different days and I still get the
same message. I think something else is going on. Any ideas?
sqladmin
2/22/2006 1:28:49 PM
could try the following from qa.

alter database mydb
set offline
sqladmin
2/22/2006 1:29:32 PM
could try the following from qa.

alter database mydb
set offline
AddThis Social Bookmark Button