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.sqlmonster.com
How about the file_size in the BackupFile system table?
Andrew J. Kelly SQL MVP
"Robert Richards via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:a46bfcae27494128849870935f2de9b3@.SQLMonster.c om...
>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.sqlmonster.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.sqlmonster.com
|||OK then how about Backup_Size in sysbackuphistory?
Andrew J. Kelly SQL MVP
"Robert Richards via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:5d56319a8f704287b2cbe0cc361395fc@.SQLMonster.c om...
> 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.sqlmonster.com
|||I am running SQL 2000 and do not seem to be able to find sysbackuphistory.
Message posted via http://www.sqlmonster.com
|||I am sorry I meant the BackupSet system table.
Andrew J. Kelly SQL MVP
"Robert Richards via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:13e45dbcb76d4537a615b957827d5d8a@.SQLMonster.c om...
>I am running SQL 2000 and do not seem to be able to find sysbackuphistory.
> --
> Message posted via http://www.sqlmonster.com
sql
No comments:
Post a Comment