使用單一使用者模式還原資料庫

alter database vatc4 set single_user with rollback immediate;
go;
RESTORE DATABASE [VATC4] FROM  DISK = N'D:\Tools\04Temp\20090324.bak' WITH  FILE = 1,  MOVE N'VATC4_Data' TO N'E:\DB\家樂福\VATC4.mdf',  MOVE N'VATC4_Data2' TO N'E:\DB\家樂福\VATC_1.mdf',  MOVE N'VATC4_Log' TO N'E:\DB\家樂福\VATC4.ldf',  NOUNLOAD,  REPLACE,  STATS = 10;
go;
ALTER DATABASE VATC4 SET multi_user;
go;