Home Forums SQL Server 2005 Administering Total backup size of backup of all databases in every month from backupset table in msdb RE: Total backup size of backup of all databases in every month from backupset table in msdb

  • August 20, 2012 at 2:00 am

    #1527459

    select convert(varchar,date_time,101), sum([Database Size in(MB)]) 'DB_Size inMB', [DB Name]

    from #t1

    group by convert(varchar,date_time,101),[DB Name]

    order by convert(varchar,date_time,101)

    try this.

    Regards
    Durai Nagarajan