declare @name nvarchar(50) declare @datetime char(14) declare @path nvarchar(255) declare @bakfile nvarchar(255) set @name='DBNAME' set @datetime=CONVERT(char(8),GETDATE(),112)+REPLACE(CONVERT(char(8),getdate(),108),':','') set @path='D:\DBDataBackup' set @bakfile=@path+''+'Bak_'+@datetime+'_'+@name+'.bak' select @bakfile backup database @name to disk=@bakfile with name=@name,checksum