IF EXISTS(SELECT name FROM master.dbo.sysdevices WHERE name = N'mx_hr_backup')
EXEC sp_dropdevice 'mx_hr_backup' // 删除原备份设备
GO
DECLARE @filename VARCHAR(255)
DECLARE @now AS DATETIME
SELECT @now = GetDate()
SELECT @filename = 'C:\Program Files\Wizit Software\Wiz_HR\mx_hr_' + //备份文件主文件名
CAST(DATEPART(yyyy, @now) AS VARCHAR) +
CAST(DATEPART(mm, @now) AS VARCHAR) +
CAST(DATEPART(dd, @now) AS VARCHAR) +
CAST(DATEPART(hh, @now) AS VARCHAR) +
CAST(DATEPART(mi, @now) AS VARCHAR) +
CAST(DATEPART(ss, @now) AS VARCHAR) +
CAST(DATEPART(ms, @now) AS VARCHAR)
IF EXISTS(SELECT * FROM sysobjects WHERE id = OBJECT_ID(N'xm_hr'))
BEGIN
EXEC sp_addumpdevice 'disk', 'mx_hr_backup', @filename // 添加备份设备
BACKUP DATABASE xm_hr TO mx_hr_backup WITH INIT // 备份数据库
END
GO