Take Offline - Bring Online
-
Have just upgraded from SQL Server 2K to 2005 and have several databases that were taken offline in Enterprise Manager. I cannot find any way of bring them back online in Management Studio. Anybody know if this is possible?
-
OK beeing stupid - I have found that I can "Bring Online" and "Take Offline" databases on SQL Servr 2K using Management Studio (by right-clicking DB and selecting Tasks". However these tasks are not present when managing databases running under 2005 - has this feature been completely removed? Bit of a shame if so - it was extremely useful for taking a quick copy of an MDB file with minimal DB downtime.
-
Yeah - pity it's not there on the mouse menu.
You can ALTER DATABSE <DBname> SET OFFLINE
-
Thanks ever so - the ALTER SQL works just fine!
-
Try this
Right click on database - Tasks - Take Offline
Right click on database - Tasks - Bring Online
-
That's the problem Bhavin - Take Offline / Bring Online are no longer in the Tasks menu when you right click on a database. They have been removed from Management Studio when you are managing SQL Server 2005 (although still present when you are managing a SQL Server 2000). Allen is correct, the only way to perform these tasks on a SQL Server 2005 database is to use ALTER DATABASE.
-
No Julian....
It is MS SQL Server 2005. Result of select @@version on the same SQL Server.
Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)
Oct 14 2005 00:33:37
Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
Attaching the screen-shot of the same for your ref
-
How strange Bhavin - these items are definately not present in Management Studio for me (when managing SQL Server 2005), I am using version 9.00.1399.00.
-
is it a CTP version ?
-
No it is the production release trial version of SQL Server 2005 (problem occurs in x32 and x64 versions).
Viewing 10 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply