Hi all,

Thank you for all the help.

I have got the reqd result using sp_MSForeachtable.....

dram

Hi All,

Thank you for your suggestions,i will try them.

dram

Hi,

Thank you all, for helping me to get the required backup size from the msdb database. 

It really saved a lot of time for me.

Dram.