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 |
|
sqlmyworld
Starting Member
38 Posts |
 Posted - 2011-09-22 : 19:36:31
|
| I have created DB maintenance plan for SQL server 2000 which takes FULL backups of all user databases every night at 8:30 PM and remove database backup files that are older than 3 days.This maintenance plan works fine except Thursday night. It backups db regularly but when it removes file, ONLY Thursday night it couldn’t remove particularly ONE DB FILE which is older than 3 days which means the ONE DATABASE has MONDAY NIGHT BACKUP file exists after finished maintenance on Thursday. Again, on Friday night the maintenance plan deletes two files for same database. So it deletes both old backup files (MONDAY AND TUESDAY) on Friday night for that particular DB.Does anyone know why only one DB has issue for deleting old backup file on Thursday only?Thanks in advance. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sqlmyworld
Starting Member
38 Posts |
Posted - 2011-09-22 : 19:56:02
|
| Tara,I quickly check with our Infrastructure guy and found that tape backup software scheduled/started at 9:00 PM and this DB maintenance plan normally finished around 8:50 PM. Even I checked prevously finished maintenance plans log files and it all normally finish around 8:45 to 8:50 PM (Before tape backup schedule job started). |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
DB Admin - DB maintenance task issue