I can delete a backup... but how to delete the logs in EM?

microsoft.public.sqlserver.programming

30 Jun 2005 4:55 PM

Star

Hi,

I have been able to delete a backup just using this:

exec master..xp_cmdshell 'DEL e:\databases\MYBACKUP.bak'

However, If I go to EM and I click on 'Restore Database' I still can
see that backup listed there. Is there anyway to update those logs?

Thanks a lot

30 Jun 2005 5:15 PM

John Bell

Hi

Look at sp_delete_backuphistory in the msdb database. More information
about it's usage is in Books Online.

John

Show quote

"Star" wrote:

> Hi,
>
> I have been able to delete a backup just using this:
>
> exec master..xp_cmdshell 'DEL e:\databases\MYBACKUP.bak'
>
> However, If I go to EM and I click on 'Restore Database' I still can
> see that backup listed there. Is there anyway to update those logs?
>
> Thanks a lot
>

30 Jun 2005 5:37 PM

Star

Thanks for the information. That works, but unfortunately I cannot
specify a range or a specify backup...

1 Jul 2005 7:25 AM

John Bell

Hi

But if you looked at the code you can work out how to create your own
procedure.

John

Show quote

"Star" wrote:

> Thanks for the information. That works, but unfortunately I cannot
> specify a range or a specify backup...
>