数据库数据备份

DECLARE @DateTimeStr NVARCHAR(20)
SET @DateTimeStr = CONVERT(NVARCHAR(20), GETDATE(), 112) + '_' + REPLACE(CONVERT(NVARCHAR(20), GETDATE(), 108), ':', '')

DECLARE @BackupFileName NVARCHAR(500)
SET @BackupFileName = N'D:\beifen\WaterIntake_' + @DateTimeStr + N'.bak'

BACKUP DATABASE WaterIntake TO DISK = @BackupFileName WITH INIT