sarvesh singh (8/4/2009)There are two maintenance cleanup task. One with extension BAK and the other with TRN for deleting files older than 2days. But this is not working.
You don't by chance have the extension setup as .BAK and .TRN do you? If you have the period in there, the task will generate the name with two periods and won't find any of the files to be deleted. Verify also that you don't have a typo in the path.
No, i have one task which does both the Full Back up and Transaction log Back up. This works fine.
I disagree with you here - this does not work fine. There is really no use to backing up the transaction log once a day. You should have a separate job that backs up the transaction log at least every hour - if not more often. I suggest you read the article I link to in my signature about Managing Transaction Logs.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs