September 22, 2009 at 8:33 am
We just rebuilt a cluster and migrated to 64 bit. Everything is fine except the maintenance tasks to delete the old backup files will not work. I have tried every variation and I can run it from QA and I get no error, but no delete. The files are all in subfolders under a t:\sqlbackup directory. I have tried deleting from the specfiic directories, and from the main folder nothing works. Here is the last command I tried. Anyone seen this before?
EXECUTE master.dbo.xp_delete_file 0,N'\\cmsphdb\sqlbackups\',N'*.trn',N'2009-09-21T09:23:16',1
September 22, 2009 at 8:49 am
Check permission... Thats all I can think off
-Roy
September 22, 2009 at 8:53 am
This is a known bug that should be fixed with SP1, but it wasn't.
The tricky solution is to remove a dot (.) in front of .bak or .trn extention in your code.
September 22, 2009 at 10:55 am
So, Your line of code should be like that:
EXECUTE master.dbo.xp_delete_file 0,N'\\cmsphdb\sqlbackups\',N'trn',N'2009-09-21T09:23:16',1
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply