Sunday, March 11, 2012

backup problem

I have a 30 gig SQL 2000 database to backup to disk. The problem is I only
have 20 gigs free on the server after the backup is done. When a new backup
is created it doesn't delete the old one until after it tries to write the
new one. How can I set the full backup (t log backups run every hour) to
delete the previous days full first and then write the new one.
Tia
jj
"jj" <jeff_detoro@.urmc.rochester.edu> wrote in message
news:ursIxSh4EHA.2428@.TK2MSFTNGP14.phx.gbl...
> I have a 30 gig SQL 2000 database to backup to disk. The problem is I
only
> have 20 gigs free on the server after the backup is done. When a new
backup
> is created it doesn't delete the old one until after it tries to write the
> new one. How can I set the full backup (t log backups run every hour) to
> delete the previous days full first and then write the new one.
You'd have to do this by hand. (i.e. it's not a default option).
however, what happens if you delete the old backup and full backup fails for
some reason (say the database becomes corrupt before the latest backup?)
I'd get a bigger disk.
(or one option which we use is a NAS like a snap server... lots of room,
RAID, etc.)

> Tia
> jj
>

No comments:

Post a Comment