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
