Comments
2 comments
-
The ERASEFILE = 1 means it will delete any files older than 24 hours. Maybe they were created the day before, but aren't over 24 hours old?
You could try using ERASEFILES = 23h to delete any files older than 23 hours for example. -
I ran the job this morning at 9:02 am and there was a file out there creeated on 1/15/08 at 7:13 pm and it didn't get delted. It is well over the 24 hrs from when it was created. Any idea why this would be happening?
Add comment
Please sign in to leave a comment.
EXECUTE master..sqlbackup N'-SQL "BACKUP DATABASE [DW_Data_Mart] TO DISK = ''D:\MSSQL\Backups\DW_Data_Mart\<AUTO>.sqb'' WITH COMPRESSION = 1, ERASEFILES = 1, INIT"' :?:
:?: :?: :?: :?: