declare @filename nvarchar(100)
set @filename='D://back/XHSQJY_'+replace(replace(replace(replace(CONVERT(char(16), getdate(), 120 ),'-',''),'',''),':',''),' ','') +'.bak'
-- print @filename
BACKUP DATABASE [XHSQJY] TO DISK = N'D:/back/XHSQJY' WITH NOINIT , NOUNLOAD , NAME = N'XHSQJY 备份', NOSKIP , STATS = 10, NOFORMAT
set @filename='D://back/XHSQJY_'+replace(replace(replace(replace(CONVERT(char(16), getdate(), 120 ),'-',''),'',''),':',''),' ','') +'.bak'
-- print @filename
BACKUP DATABASE [XHSQJY] TO DISK = N'D:/back/XHSQJY' WITH NOINIT , NOUNLOAD , NAME = N'XHSQJY 备份', NOSKIP , STATS = 10, NOFORMAT