Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dewacorp.alliances
452 Posts |
 Posted - 2003-05-20 : 19:56:09
|
| Dear allWe have weird issue regarding the database maintenance plan. We setup database maintenace plan using a wizard and in the Complate Backup Wizard tab -> Disk -> Tick "Remove files older than : 4 weeks".But when we check the old files ... the files (more than 4 weeks) still there anyway?Any reason why? I also check the SQLServer Agent and they're running fine.Any suggestion or hint or anything ... I'm really appreciated.ValdyEdited by - valdyv on 05/20/2003 19:57:09 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-05-20 : 20:01:55
|
| Does the account that runs the job have the necessary privileges to delete a file in the directory where the full backups are located? Are there any errors in the SQL Server Error Log? If you look at the job history for the job that runs this maintenance plan (show details), does it say successful when it removed the files?Tara |
 |
|
|
|
|
|
Database Maintenace Plan Issue