Monday, February 20, 2012

Removing Backups

Hello,
We do our own backups i.e.
Where filename is the name of the database with a
timestamp.
EXEC sp_addumpdevice 'disk', @.FileName, @.Filename.
Backup database ParisTestProduction to @.FileName.
Is there a safe way to remove the backup history and file,
or will I need to write one.
BTW we cannot use the 'Database Maintenance Plan'
thanks for your help
Peter
to remove backup history try sp_delete_backuphistory
to delete your old backup probably you must write script
mous@.discussions.microsoft.com> wrote in message
news:23ac01c427b8$ff698e30$a401280a@.phx.gbl...
> Hello,
> We do our own backups i.e.
> Where filename is the name of the database with a
> timestamp.
> EXEC sp_addumpdevice 'disk', @.FileName, @.Filename.
> Backup database ParisTestProduction to @.FileName.
> Is there a safe way to remove the backup history and file,
> or will I need to write one.
> BTW we cannot use the 'Database Maintenance Plan'
> thanks for your help
> Peter
|||Thank you
Peter
[vbcol=seagreen]
>--Original Message--
>to remove backup history try sp_delete_backuphistory
>to delete your old backup probably you must write script
>mous@.discussions.microsoft.com> wrote in message
>news:23ac01c427b8$ff698e30$a401280a@.phx.gbl...
file,
>
>.
>

No comments:

Post a Comment