How to edit backup history

I am using SQL Enterprise manager to manually backup test databases on
my PC.
As time goes on the list of backups is getting long and cumbersome,
and I no longer need many of them
Is there a way I can remove entries from the backup history for a
specific database to tidy up the even increasing list.
Thanks for any help
RichardF
Hi,
Use the system procedure:-
USE msdb
go
EXEC sp_delete_backuphistory '07/20/2004'
Deletes all the history older than july 20 2004. But there is no option to
clear the histories for a sinle database
Thanks
Hari
MCDBA
"RichardF" <no.one@.no.where.com> wrote in message
news:41114edb.172348764@.msnews.microsoft.com...
> I am using SQL Enterprise manager to manually backup test databases on
> my PC.
> As time goes on the list of backups is getting long and cumbersome,
> and I no longer need many of them
> Is there a way I can remove entries from the backup history for a
> specific database to tidy up the even increasing list.
> Thanks for any help
> RichardF
|||There is a separate proc to delete the history of a single database:
EXEC msdb.dbo.sp_delete_database_backuphistory dbname
You cannot specify a date however - it will delete all the backuphistory data
JustinR
"RichardF" wrote:

> I am using SQL Enterprise manager to manually backup test databases on
> my PC.
> As time goes on the list of backups is getting long and cumbersome,
> and I no longer need many of them
> Is there a way I can remove entries from the backup history for a
> specific database to tidy up the even increasing list.
> Thanks for any help
> RichardF
>