Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.
DECLARE @backupDate nvarchar(8) declare @deletedate datetime declare @statement nvarchar(100) set @backupDate =cast(day(getdate())as nvarchar) +cast (month(getdate())as nvarchar) +cast (year(getdate())as nvarchar) select @deletedate= DATEADD(dd,-3,GETDATE()) execute xp_delete_file 0, 'D:\Development\Menafn_Sql_Backup_daily', 'bak', @deletedate set @statement ='BACKUP DATABASE menafn TO DISK = ''D:\Development\Menafn_Sql_Backup_daily\menafnfullbackup' +@backupdate+ '.bak''' execute (@statement)
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.