August 27, 2008 at 11:49 pm
Hi Freinds,
Could you please help me with the below issue.
Is there any way to calculate daily backups(Full, diffrential and log backups) growth at disk level. Is there any query or procedure in SQl 2000 or 2005.
I would like to keep track of the backup size growth and accordingly plan my disk space.
Regards,
Rajini
August 28, 2008 at 12:17 am
Look in the msdb..backupset table. It contains details of backups (database name, backup type, backup size, backup date etc).
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
August 28, 2008 at 2:25 am
Thanks for the info. However the backupset table provides only the log backup information.
-Rajini
August 28, 2008 at 3:52 am
The 'type' column in msdb..backupset identifies the various different backups that have been made. Either you are not using the SQL Server BACKUP command to perform your backups (perhaps a 3rd party tool that backs up your databases in another manner) or your backup history tables are periodically purged of old entries (e.g. using msdb..sp_delete_backuphistory).
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply