Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks
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.