sp_delete_backuphistory not working

1 vote

1 answer

857 views

sql-server-2008-r2 msdb

                          I am using sql Server 2008 R2.
We are using below query for reducing the msdb size.

    use msdb exec sp_delete_backuphistory '01-MAR-2020' 

When i execute this query in  server whose msdb size is 15GB no rows were deleted.
Some testing server with lesser rows it worked fine. 

Why  is it  not working ? How to reduce the msdb size is there any other method?
                        

Asked by IT researcher (3178 rep)

Jul 2, 2020, 06:35 AM
Last activity: Jul 3, 2020, 12:25 PM

sp_delete_backuphistory not working

Related Questions