﻿ALTER DATABASE shop  SET SINGLE_USER with ROLLBACK IMMEDIATE  USE master  RESTORE DATABASE shop FROM DISK= N'G:\c#\Cms Shoping\cmsarya\cmsarya\Cr-Admin\Backup\1405-08-07.BAK' WITH REPLACE