June 8, 2008 at 11:45 pm
Issue is related to maintenance plan on 2005. Backups of 5 user databases are taken at below location using maintenance plan
T:\SQLBACK
A maintenance plan clean up task is also added that deletes the .BAK files older than 3 days. But here, when I check I see that the .BAK files are not getting deleted. Have you encoutered this problem before.
Please advise on the same.
Thanks.
M&M
June 8, 2008 at 11:55 pm
There was a issue with sql 2005 but its being corrected in the subsequent service pack release.... dont remember which service pack though.
Which version are u using and what is the backup file extension that you have given. File extension should be ".bak", it should include the dot "." .
check out the ms site for more details.
"Keep Trying"
June 9, 2008 at 12:10 am
Product version is 9.00.3054.00
service pack sp2
I am using .BAK extension only
M&M
June 9, 2008 at 4:26 am
Hi
Have you set the folder correctly? Are there backup files older than 3 days in your backup folder?
check out these links
http://www.sqlservercentral.com/Forums/Topic361562-149-1.aspx
http://www.sqljunkies.com/WebLog/mz1313/archive/2006/04/03/20010.aspx
seems i was wrong about the extension name for the file.
"Keep Trying"
June 10, 2008 at 7:30 am
Upgrade to version 9.00.3175. The problem is fixed in that version.
June 10, 2008 at 7:34 am
SP2 had an issue and there were updates postSP2 that corrected issues with this task.
June 11, 2008 at 12:16 pm
1. Make sure you are on sp2. I see no reason not to upgrade at this point.
2. For the file extension, use "bak" instead of ".bak". I've run into this issue before and as soon as removed the DOT, everything worked fine.
Good luck!
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply