March 19, 2009 at 9:07 am
Hello all,
I am supporting a production database with small size.
In that backup activity is running on daily basis. The retention period for backup files is 3 days only.
For that I have created a maintenance job in that I am running maintenance clean up task first and then the DB backup task (I am taking all DB backup in respective folders).
But after running that job I noticed that the system databases (master, model,msdb) backup files counts are only three (obviously...), but the other user database file counts are four....
so may I know the cause of the above scenario and also solution on it..?
Supporting Info:
The backup job is running on 1:00 AM
March 20, 2009 at 7:03 am
This depends the timestamp of the backup file. In your cases, the 3 days old files are not old enough ( say 2 days, 59 minutes, 55 sec ) to be deleted. Hence the files are retained for one more day.
You should run the clean up task after 10 minutes of your backup activity and this will solve the problem.:-)
March 21, 2009 at 1:31 am
Some possible problems.
1.Tape backup my be blocking the file from deletion .
2.Also check SQL server startup account has modify permission for respective folders and file level too
3. As last option ,delete the maintenance task and write a select script to get files older than 3 days & delete it , add this as a first step
March 26, 2009 at 2:03 am
Hi Atul,
I have solved problem with the solution given by you.. thanks.
March 27, 2009 at 3:38 am
Nice to hear this. Cheers.:-)
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply