• Use dbname

    Go

    Select count(Total_pages), count(used_pages) , sum( total_pages* 8) TotalPagesKb, sum(used_pages * 8 ) Usedpageskb from sys.allocation_units

    I am not sure above query will help you 100%, but you may get an idea about of your backup size will be.