ALTER DATABASE [datebase] SET OFFLINE WITH ROLLBACK IMMEDIATE
用完之后再
alter database [dbname] set online
第二种方法:
RESTORE DATABASE U2000 FROM
DISK = N'D:\data\u2000_backup_201208310000.bak' WITH FILE = 1,
NOUNLOAD, REPLACE, STATS = 10
GO
原文:http://kb.cnblogs.com/a/1661095/