http://stackoverflow.com/questions/847076/sql-script-to-take-a-microsoft-sql-database-online-or-offline
If you run the ALTER DATABASE
ALTER DATABASE database - name SET OFFLINE
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
SQL Script to take a Microsoft Sql database online or offline
最新推荐文章于 2024-07-25 15:27:34 发布