Maintenance Job
I made a Maintenance plan for my SQL 2005 databases, that include
Back Up Database Task, Maintenance Cleanup Task and Shrink Database Task in ordered way. and link thier arrows so the first is bkup and the last is shrink.
The problem is there is no errors message or logs indicating that there is an error!!!.
Note: I check my backup file results and notice that some days its delete the old files and somedays its not delete the old files (I set to delete old file that is older than 2 days).
Mohd A. Shalabi
__________________
Mohd A. Shalabi
|