Can anyone tell me the difference between the filesize values being logged
in the Backupfile and Backupset tables in the msdb database.
I am a little confused as the data for the backup on a same day registers
different file sizes. Also can anyone give me a little more idea on what
each of these tables are being used for.
Thanks
Hi
In BackupSet, there is a column 'backupsize'. This value isthe size, in
bytes, of the backup dumped to tape/disk.
In BackupFile, there is a column 'filesize'. This is the actual size of the
device files that are currently configured for the DB, that have been backed
up in the BackupSet..
Definitions from systbl.chm:
backupfile
Contains one row for each data or log file that is backed up. This table is
stored in the msdb database.
backupset
Contains a row for each backup set. This table is stored in the msdb database.
Regards
Mike
"Rahul Chatterjee" wrote:
> Can anyone tell me the difference between the filesize values being logged
> in the Backupfile and Backupset tables in the msdb database.
> I am a little confused as the data for the backup on a same day registers
> different file sizes. Also can anyone give me a little more idea on what
> each of these tables are being used for.
> Thanks
>
>
No comments:
Post a Comment