Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
driesb
Starting Member
3 Posts |
 Posted - 2005-04-06 : 05:28:48
|
| We use the standard maintenance routines tobackup all databases to another server every night. Part of the routine should be that old backup files are deleted (remove all files older than 1 day is checked) but we find that very regularly these old files do not get deleted.Does anybody have a clue as to why this is?Thanks!Dries |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-04-06 : 08:44:59
|
| Not using maint plans should solve it.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-04-06 : 08:53:59
|
The maintenance plans are pretty unreliable as Nigel was pointing out.  Take a look at Tara's scripts:http://weblogs.sqlteam.com/taradMeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-04-07 : 01:25:31
|
| or you can create a batch file, schedule this and delete the files--------------------keeping it simple... |
|
|
|
driesb
Starting Member
3 Posts |
Posted - 2005-04-07 : 03:51:18
|
| Actually, I think I found the source of the problem because of a remark I read somewhere about the order in which things get done.Stupidly I assumed that the server backs up one database, deletes the old version, backup the next database, delete old version, etc.Logically such sequence would notmake sence but ok. New assumption is that the server does a backup of all databases first and then deletes the old files. This would match the problems we have whereby a number of files get backed up, there is not enough diskspace for a full second set ofdatabase backup files so the process crashes handling one of the large files and the old files do not get deleted. Next day it start again and does some of the files until it hits one of the large ones again, crashed, does not delete, etc etc etcSolution was to move the backup to a drive where whe have enough space to keep multiple complete sets and that should sort out the problem for us. Last night the backup went ok so fingers crossed.Thanks for all your advise,Dries |
|
|
|
kish
Starting Member
45 Posts |
Posted - 2005-04-07 : 06:16:06
|
| And yes, SQL Maintainence Plans are very reliable. I have usign my backup strategy for Full and T-Log backups with deletions for last 4 years with no problems at all. The only thing is you should know how to plan them properly. --Kishore |
|
|
|
|
|
|
|
|
Old backup files are not deleted