sample code declare @d1 varchar(20)= FORMAT(GETDATE(), 'yyyyMMdd_HHmmss') declare @f1 varchar(100) = 'C:\sampleDB3back\sampleDB3_' + @d1 + '.bak'; backup database sampleDB3 to disk = @f1 www.microsoft.com