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
Peterto 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
>--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,[vbcol=seagreen]
>
>.
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment