I've got our production Great Plains db's on SqlServer 2005. In management
studio, I've defined my maintenance tasks to backup the db's (34 - each
company is a separate database) into separate subdirectories. The backup is
fine, but deleting the older backups (2 days) is difficult. In the
"maintenance" task, it only specifies one directory that you can delete
from.

Someone told me that SP1 fixes this, but I didn't see it in any of the
fixes, but I might not be looking at the right spot.

sp1 has an option (checkbox) to traverse first-level subdirectories in the clean-up task.

Show quoteHide quote

Yes, SQL Server 2005 SP1 provides an option "Include first-level
subfolders" in "Maintenance Cleanup Task".

Thanks for using Microsoft Managed Newsgroup. If you have any other
questions or concerns, please feel free to let us know.

Charles Wang
Microsoft Online Community Support
======================================================
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================

BCP genric error
Problem on scripting stored procedures
Telling if SQL2005 is running
SMSS - script to new window uses sp_executesql?!
error importing data from Access to SQL Server