Hey all, I'm experiencing a strange issue with my SQL Maintenance Cleanup Task. I have it configured to delete old backup files with a "bak" extension that is older than 2 days. When I view the TSQL on the job it looks like this:
However, when I look at the job history and check the TSQL that ran, it's missing the "bak" extension.
EXECUTE master.dbo.xp_delete_file 0,N''B:\Backups'',N'''',N''2017-01-21T07:49:43'',1
GO
Anyone know why that would be?
I have a similar job for transaction logs that is configured the same, except to delete "trn" files and that one executes flawlessly, which has added to my mystification on this. Thanks for any help.
Question
Stokkolm
Hey all, I'm experiencing a strange issue with my SQL Maintenance Cleanup Task. I have it configured to delete old backup files with a "bak" extension that is older than 2 days. When I view the TSQL on the job it looks like this:
However, when I look at the job history and check the TSQL that ran, it's missing the "bak" extension.
Anyone know why that would be?
I have a similar job for transaction logs that is configured the same, except to delete "trn" files and that one executes flawlessly, which has added to my mystification on this. Thanks for any help.
Link to comment
https://www.neowin.net/forum/topic/1320182-sql-maintenance-job-issue/Share on other sites
1 answer to this question
Recommended Posts