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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-09-24 : 07:56:32
|
| Brian writes "Do you know why the DB Maintenance Plan does not delete the transaction logs older than the time that us specify? For example, I have told SQL Server to Backup nightly and transaction Logs twice daily and to remove files older than a week. I still have transaction logs going back more than that date. I am currently using the 2K version with SP3. Any knowledge on the subject would be greatly appreciated!Brian" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-24 : 12:31:43
|
| Does the account that the SQLSERVERAGENT log on as have permissions to delete files? How much older than a week are the files? You might want to delete the maintenance plan and then recreate it to see if that fixes it. What service pack for SQL Server 2000 are you using?Tara |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-09-24 : 12:58:08
|
| Alternatively write a script to do the backups then you aren't reliant on whatever the maint exe decides to do.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
DB Maintenance Log