May 13, 2008 at 1:45 pm
Hi all,
How can i find out what is the size of backup file that baked up everyday but usind T-SQL?
Thanks
PAt
May 13, 2008 at 1:47 pm
Look in the msdb.dbo.backupset table.
May 13, 2008 at 1:54 pm
but backup_size!!
is it in kb or mb i need that in GB if possible!!
thanks
Pat
May 13, 2008 at 2:02 pm
If you look in BOL you'll find all the information you want and were afraid to ask about the table backupset.
You will find there that the file size shown in the table is in bytes. Divide by 1024 to get KB, divide by (1024 * 1024) to get MB, and divide by (1024 * 1024 * 1024) to get GB.
😎
May 13, 2008 at 2:02 pm
Check out this thread:
http://www.sqlservercentral.com/Forums/Topic478154-24-1.aspx
This gives the backups and the sizes. Looks like it's what you need.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply