pro_backupdatabase.sql

来自「一套宾馆管理系统」· SQL 代码 · 共 14 行

create procedure BackupDatabase 
@device varchar(30)
as
declare  @strfilename  varchar(20)
declare @path varchar(30)
select @path=back_filepath from backupdevice where back_name=@device
set @strfilename=convert(varchar(8),getdate(),112)+'.dat'
set @strfilename=rtrim(@path)+'\'+rtrim(@strfilename)

if not exists(select name from master.dbo.sysdevices where name=@device)
   --execute sp_dropdevice @device

   execute sp_addumpdevice 'disk',@device,@strfilename
   backup database Hotel to disk=@strfilename with init