Thank you for your response !

So basically just create a base database on the primary node and that's it ?

Thanks for the quick response... i haven't touched sql server in a while and just getting back into it 🙂

I am installing a brand new server and a base database...

Thanks for that tip !

I had to create a separate maintenance plan and the suffix was also wrong ... apparently it's a bug in sql 2005.

Now it works

I even created a new plan and executed it manually and the files do not get deleted.

Very strange

This is what I have for the maintenance cleanup of the transaction log backup plan

EXECUTE master.dbo.xp_delete_file 0,N''E:\backups\tkcsdb\logs'',N''.trn'',N''2008-08-27T13:00:01''

I see older files in the directory that are supposed to be gone 🙁

That's what I have also !

I see it as part of a maintenance plan in the history log ( log file viewer) but nothing else.

Very frustrating

Actually I did add later after the pans were created and the green links are there

server agent is indeed active

Yep ... age and path are correct

Is there and agent that is supposed to run for this?

This cleanup is not working in 2 maintenance plans

This is a new sql 2005 install and I have indeed added the task to the maintenance plan and created that link but old files specified are still there as...

Same problem here and the old files are not being deleted ?

I apologize as I have created a duplicate thread

Hi Vee... thanks for those tips , I'll try these different things and see if the file is better managed.

I verified the TLOG backups and they are done every hour. The log file is relatively small ( 800 mB ) after the backup, but then at any given time...

Thanks ! will let you know the results.

JR