数据库备份还原（备份设备方式）

 

--还原

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]