USE MarketShareTool; GO declare @path nvarchar(max) set @path= 'E:/MarketShareDBBakups/MarketShareTool ' + cast(Convert(date,SYSDATETIME()) as nvarchar(50)) +'.bak' BACKUP DATABASE MarketShareTool TO DISK = @path WITH FORMAT, MEDIANAME = 'Z_SQLServerBackups', NAME = 'Full Backup of MarketShareTool'; GO