backup data

 declare @path varchar(500)='F:\backup\db_'+cast(DATEPART(YEAR,GETDATE()) as nvarchar(1000))+'_'+cast(DATEPART(MONTH,GETDATE()) as nvarchar(1000))+'_'+cast(DATEPART(DAY,GETDATE()) as nvarchar(1000))+'_'+cast(DATEPART(HH,GETDATE()) as nvarchar(1000))+'_'+cast(DATEPART(MI,GETDATE()) as nvarchar(1000))+'.bak'

BACKUP DATABASE [db]

TO  DISK = @path

WITH CHECKSUM

• Tweet
• Share
• Share
• Share
• Share

Sign up here with your email