--还原
use master DECLARE @sSql VARCHAR(255)
EXEC('ALTER DATABASE [PatentEx_region] SET OFFLINE WITH ROLLBACK IMMEDIATE')
SET @sSql = 'RESTORE DATABASE [PatentEx_region] FROM DISK = ''D:/新建文件夹/33'' with REPLACE '
EXEC(@sSql)
EXEC('ALTER DATABASE [PatentEx_region] SET ONLINE WITH ROLLBACK IMMEDIATE')
--备份
use master declare @dbname nvarchar(50)
if exists (select * from sysdevices where [phyname]=N'D:/新建文件夹/44')
begin
select @dbname = [name] from sysdevices where [phyname]=N'D:/新建文件夹/44'
exec sp_dropdevice @dbname
end
exec sp_addumpdevice 'disk', '3893f049bdf244a6873c7e8ed46514faPatentEx_region','D:/新建文件夹/44'
BACKUP DATABASE [PatentEx_region] TO [3893f049bdf244a6873c7e8ed46514faPatentEx_region]