Yes understood. It seems MS have managed to cause fairly widespread confusion over that :rolleyes:

Excellent thanks Perry!

Excellent I'll try that.

(I have RSScripter - it's brilliant but doesn't do SQL Agent jobs)

Thanks,

signal_runner

Bump. Anyone?

I don't want to relegate it to the sparsely populated realm of impossibility.

understood - thanks.

Hi - thanks for the script, it's great.

I have one (probably rookie) question: It appears to only select from msdb.dbo.backupmediafamily where device_type = 2. We have some backups where the...

Yes - I've also found that. For some indexes, the LogicalFrag never reduces further than a certain value. This may be because there are very few values in the...

cancel that - my question has been answered already by Grant Fritchey:

http://www.sqlservercentral.com/Forums/Topic1288649-2799-1.aspx

Thanks.

Yeah I'm kind of torn about this. It's an indicative demonstration I guess.

There's no denying that for scripts that need to do automated and extremely nifty things, powershell is probably...