Desperately Seeking Susan.. or the yearly media

[manatee]

Happy New Year!!

pardon the subject can't help it ;)  i have several year end backup policies that have finished and am looking for how to find all the media it uses. i tried the catalog but i can't change the policy type to SQLServer. it is greyed out at MS-Windows.

how to find all the media used by a particular backup policy?

[Marianne]

In addition to @sdo's excellent post, we already know that your MSDP disk pool is WAY too small.

A quick win will be to double existing MSDP pool. 

If you can extend the retention of MSDP images to at least 2 weeks, then most restores will be done from disk without impacting other operations.
You will also see MUCH better dedupe rates with longer retention on disk.