Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.
Msg 22049, Level 15, State 0, Line 0
Error executing extended stored procedure: Invalid Parameter
Processed 1816968 pages for database 'menafn', file 'menafn_Data' on file 1.
Processed 1574 pages for database 'menafn', file 'menafn_Log' on file 1.
BACKUP DATABASE successfully processed 1818542 pages in 661.304 seconds (21.483 MB/sec).
DECLARE @backupDate nvarchar(8) declare @deletedate datetime declare @statement nvarchar(200) set @backupDate =cast(day(getdate())as nvarchar) +cast (month(getdate())as nvarchar) +cast (year(getdate())as nvarchar) select @deletedate= DATEADD(dd,-7,GETDATE()) execute xp_delete_file 0, 'Menafn_Sql_backup_weekly', 'bak', @deletedate set @statement ='BACKUP DATABASE menafn TO DISK = ''C:\Menafn_Sql_backup_weekly\menafn_weekly_' +@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.