Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
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)
Join the community of 500,000 technology professionals and ask your questions.