Delete previous backup in append mode sql 2000

i have set backup of userdatabases in append mode every day
its possible to remove backups of a previous date using a stored
procedureAre you saying that you append to the same backup device and now want to overwrite only some of the
backups on that backup device? If so, the answer is "no". It is all or nothing.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Arejan" <areejan2000@.yahoo.com> wrote in message
news:1165601458.685473.96490@.j72g2000cwa.googlegroups.com...
>i have set backup of userdatabases in append mode every day
> its possible to remove backups of a previous date using a stored
> procedure
>|||writing the backup daily to hdd
whats the better option so that the file size is maintained ,can only
use append mode
as i might want to restore to 2/ 3 days previous data|||Using Append you will never be able to keep exactly three (or two, or
six) copies of your backup. Rather than using append modeUse a
different file name each day, perhaps with the date as part of the
file name.
Roy
On 10 Dec 2006 21:15:08 -0800, "Arejan" <areejan2000@.yahoo.com> wrote:
>writing the backup daily to hdd
>whats the better option so that the file size is maintained ,can only
>use append mode
>as i might want to restore to 2/ 3 days previous data