SQL维护清理任务正在工作但不能删除 [英] SQL Maintenance Cleanup Task Working but Not Deleting

问题描述

我有一个维护计划，该计划应该通过BACKUP文件夹并删除所有5天之前的.bak.当我运行该作业时，它会向我发送成功消息，但是仍然存在较旧的.bak文件.

I have a Maintenance Plan that is suppose to go through the BACKUP folder and remove all .bak older than 5 days. When I run the job, it gives me a success message but older .bak files are still present.

我已尝试解决以下问题: https://serverfault.com/questions/245493/sql-maintenance-cleanup-task-success-but-not-deleting-files

I've tried the step at the following question: https://serverfault.com/questions/245493/sql-maintenance-cleanup-task-success-but-not-deleting-files

Result is column IsDamaged = 0

我已经验证了以下问题，但这不是我的问题:

I've verified with the following question and this is not my issue: https://serverfault.com/questions/94094/maintenance-cleanup-tasks-running-successfully-but-not-deleting-back-up-files

我也尝试过删除作业和维护计划并重新创建，但无济于事.

I've also tried deleting the Job and Maintenance Plan and recreating, but to no avail.

有什么想法吗?

推荐答案

尝试以下检查:

1. 对文件扩展名使用*.*或不带点的bak，如果其他问题也正确的话，我都发现它们都可以工作.
2. 确保该路径只是备份所在的路径，但最后要加反斜杠.
3. 首先创建备份时，请确保已勾选验证.

这篇关于SQL维护清理任务正在工作但不能删除的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！