This solution worked fine for me as well.

Thanks a lot.

Lucas

This has been fixed, this topic can be closed or removed. (I didn't find the option on how to do it myself)

Thanks

Luk

Your so good!!

That worked great!...once again thanks a lot!!!

I really appreciate it!

Thanks

Lucas

Bradly, today I tested it again after I had a few .trn files and 2 sets of .bak files. I run the script for each database, and I check exactly...

Thanks a lot for all your help guys.

I know this server is out of date, but for now I cannot upgrade it, but I have a project to migrate that...

Perry Whittle (5/12/2010)

---

lcibert (5/12/2010)

---

Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86) = 2005 SP1 RTM

And I cannot upgrade it because it's not supported by the application vendor for...

Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86) = 2005 SP1 RTM

And I cannot upgrade it because it's not supported by the application vendor for what I'm running...

Ok, that worked great for the bak files on the root, now I think it has deleted .trn files on the sub folders not following the rules, I'm missing log...

Query:

--**********************************************************

--Enable the ability to set advance settings and xp_cmdshell

--**********************************************************

exec sp_configure 'show advanced options', 1

go

reconfigure

go

exec sp_configure 'xp_cmdshell', 1

go

reconfigure

go

--******************************************************

--Declare variable's to use in the code and set their values

--******************************************************

declare @myTable as table...

Bradly,

First of all thanks for the help.

Now for all the first checkings, everything is...

Same thing, completes successfully, and then it does nothing, the bak's are still...

Same thing, completes successfully, but it does nothing.

Hi, I'm having the same issue, I've got the cleanup job scheduled on the Maintenance Plan, it shows as it runs fine, finishes successfully but it doesn't delete the backups...

Great!...Thanks a Lot MJ!

Lucas

I had got mixed up with other fields because this is a very large Table, but your Query works great!

Thanks a lot!

Lucas