如果不需要还原,则使用: restore database test with recovery
如果只需要还原,则使用: restore database test with norecovery
USE master;
GO
ALTER DATABASE AdventureWorks2012
SET SINGLE_USER
WITH ROLLBACK IMMEDIATE;
GO
ALTER DATABASE AdventureWorks2012
SET READ_ONLY;
GO
ALTER DATABASE AdventureWorks2012(如果单用户正在连接中,则必须停止sql服务,在运行这个语句)
SET MULTI_USER;
GO