SQL Script to take a Microsoft Sql database online or offline

转载于 2010-08-27 15:26:00 发布 · 188 阅读

文章标签：

#sql #database #microsoft #command

SQL 日志与备份还原专栏收录该内容

31 篇文章

订阅专栏

本文介绍如何使用SQL语句将Microsoft SQL Server数据库设置为在线或离线状态。包括带NO_WAIT选项的命令，以防止在用户或进程连接时阻塞命令执行。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

http://stackoverflow.com/questions/847076/sql-script-to-take-a-microsoft-sql-database-online-or-offline



ALTER DATABASE database

-
name SET OFFLINE






If you run the ALTER DATABASE


command whilst users or processes are connected, but you do not wish

the command to be blocked, you can execute the statement with the

NO_WAIT option. This causes the command to fail with an error.






ALTER DATABASE database
-

name SET OFFLINE WITH NO_WAIT






Corresponding online:



ALTER DATABASE database
-
name SET ONLINE