I've got an issue at one of the customer site where the old backups are not getting deleted. I used clean up task in maintenance plan. That didn't work. ran the below
script. That didn't work either. I have taken the date field off just to see if there was an issue with the date maybe..It doesn't seem to be the case. It's just not working.
EXECUTE master.dbo.xp_delete_file 0,N'G:\SQLBackups\SERVER3$ECLIPSE\ECLIPSE4\FULLBU\',N'bak'
I am using:
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)
Apr 2 2010 15:48:46
Copyright (c) Microsoft Corporation
Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: )
Many thanks in advance.
blog: http://sarveshsingh.comTwitter: @sarveshsing