declare @filename nvarchar(1000)--文件名
set @filename='F:\DataBack\DBName\DBName'+REPLACE(REPLACE(REPLACE(convert(varchar(16),GETDATE(),121),'-',''),' ',''),':','')+'.bak' --文件路径及文件名
print @filename BACKUP DATABASE [DBName] TO DISK = @filename WITH INIT , NOUNLOAD , NAME = N'DBName数据备份', NOSKIP , STATS = 10, NOFORMAT
go
set @filename='F:\DataBack\DBName\DBName'+REPLACE(REPLACE(REPLACE(convert(varchar(16),GETDATE(),121),'-',''),' ',''),':','')+'.bak' --文件路径及文件名
print @filename BACKUP DATABASE [DBName] TO DISK = @filename WITH INIT , NOUNLOAD , NAME = N'DBName数据备份', NOSKIP , STATS = 10, NOFORMAT
go