I am looking for a way to retrieve the size of my backup devices. When I run
sp_helpdevice, the backup devices with a cntrltype = 2 (which happen to be
the only ones I am interested in), all return a size = 0. Any idea how to ge
t the size using T-SQL?
Message posted via http://www.droptable.comHow about the file_size in the BackupFile system table?
Andrew J. Kelly SQL MVP
"Robert Richards via droptable.com" <forum@.droptable.com> wrote in message
news:a46bfcae27494128849870935f2de9b3@.SQ
droptable.com...
>I am looking for a way to retrieve the size of my backup devices. When I
>run sp_helpdevice, the backup devices with a cntrltype = 2 (which happen to
>be the only ones I am interested in), all return a size = 0. Any idea how
>to get the size using T-SQL?
> --
> Message posted via http://www.droptable.com|||That does not provide the size of the backup files (as in *.bak), but instea
d provides the files that are being backed up. I am looking for the size of
the *.bak files.
Message posted via http://www.droptable.com|||OK then how about Backup_Size in sysbackuphistory?
Andrew J. Kelly SQL MVP
"Robert Richards via droptable.com" <forum@.droptable.com> wrote in message
news:5d56319a8f704287b2cbe0cc361395fc@.SQ
droptable.com...
> That does not provide the size of the backup files (as in *.bak), but
> instead provides the files that are being backed up. I am looking for the
> size of the *.bak files.
> --
> Message posted via http://www.droptable.com|||I am running SQL 2000 and do not seem to be able to find sysbackuphistory.
Message posted via http://www.droptable.com|||I am sorry I meant the BackupSet system table.
Andrew J. Kelly SQL MVP
"Robert Richards via droptable.com" <forum@.droptable.com> wrote in message
news:13e45dbcb76d4537a615b957827d5d8a@.SQ
droptable.com...
>I am running SQL 2000 and do not seem to be able to find sysbackuphistory.
> --
> Message posted via http://www.droptable.com
No comments:
Post a Comment