Changing status of db to OFFLINE

Question

Post reply

Changing status of db to OFFLINE

rmatthias001

SSChasing Mays

Points: 604
More actions
October 20, 2010 at 10:33 am

#388053

Can someone help me with the tsql on this? i created a test table and want to set the status to OFFLINE. The following is what doesn't work.
USE master
GO
ALTER DATABASE TK432
SET db_state_option = OFFLINE;
GO
Thanks.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Did you open books online and look up the syntax for ALTER DATABASE?

ALTER DATABASE database_name

SET { ONLINE | OFFLINE | EMERGENCY }

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Steve Jones - SSC Editor SSC Guru Points: 736455 More actions · Answer 2

BOL: http://msdn.microsoft.com/en-us/library/ms174269.aspx

rmatthias001 SSChasing Mays Points: 604 More actions · Answer 3

Thanks. Yes I did but was making a stupid syntax error. Thanks again.