Problem:
ALTER DATABASE SET OFFLINE takes a long time
ALTER DATABASE SET OFFLINE takes a long time
Solution:
Close active sessions of the database:
Close active sessions of the database:
USE master
--find active sessions:
SELECT * FROM sys.sysprocesses WHERE dbid = DB_ID('MYDATABASE')
--find active sessions:
SELECT * FROM sys.sysprocesses WHERE dbid = DB_ID('MYDATABASE')
kill 52 .... and all other sessions
No comments:
Post a Comment