Thanks Jason

any idea about to specify path for t-log backup file.

my t-log backup file is on network drive.

It seems to be a powerful script . i tried on local machine and it has deleted all backup files.

so u mean to say if i want to delete 7...

@Manjunath

Hi i am working on same script. can you let me know how i can provide the network share location to delete old t-log backup file in...

HI guys maintenance plan is working and job is getting succeed but files are not deleted .

Thanks Robert for a kind reply.

I am trying with Maintenance Plan and getting error that why looking for better script.

I am trying this V script to delete old T-log backup files. but i am looking for better script if anyone has please post here.

Script i am using is:

iDaysOld...

nice script you posted. once concern so every time if i want to run this script i do have to change date ? or it will take automatically current date?

I tried you script it executed well but not deleting the file from folder.

DOes it works with sql server 2008R2?

Very good and useful script.

Did you put in production? just want to know how it works in production environment ?

thanks Jason i am checking your link.

No Not yet that what i am wondering what are the steps to finish this .

I want to create new job and target as multiple server .but i saw that option is disable . so i want to know how to setup this new job...

thanks for nice script to be posted here...

few questions like to ask .

how we can change time to run every 5 or 10 min instead of to run 2...

Hi SQLQuest29

I would like to know how did you setup EVENT_Notification

for BLOCKED_PROCESS_REPORT to find out when there is real blocking. can you explain me...