space issue

Question

space issue

ramyours2003

SSChampion

Points: 12268
More actions
January 12, 2010 at 1:59 am

#219138

we created a maintainence plan for backup and clean up job to remove the old backups more than 4 hrs as we r facing the disk space problem . the backup job ran successful but the old backup file is not deleted . what is the reason for not deleted the old backup file and how to resolve it ?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Dugi SSCoach Points: 17998 More actions · Answer 1

Do you have rights in backup folder!?

============================================================
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

ss-457805 SSCertifiable Points: 5872 More actions · Answer 2

Please ensure that you are using .BAK or .TRN for the extension instead of just BAK or TRN.

blog: http://sarveshsingh.com Twitter: @sarveshsing

homebrew01 SSC Guru Points: 55548 More actions · Answer 3

Your cleanup task should not include the period in the file type. use 'BAK' not '.BAK'

muthukkumaran Kaliyamoorthy SSCoach Points: 19026 More actions · Answer 4

ramyours2003 (1/12/2010)
we created a maintainence plan for backup and clean up job to remove the old backups more than 4 hrs as we r facing the disk space problem . the backup job ran successful but the old backup file is not deleted . what is the reason for not deleted the old backup file and how to resolve it ?

Can u post the sql version?

Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/