Showing posts with label dayits. Show all posts
Showing posts with label dayits. Show all posts

Friday, February 17, 2012

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 ove
rwrite only some of the
backups on that backup device? If so, the answer is "no". It is all or nothi
ng.
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
>

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
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