Options

How to get this kind of information programmatically?

ogrishmanogrishman Posts: 81 Bronze 4
edited March 16, 2013 3:20AM in SQL Backup Previous Versions
When I hover my mouse over a sqb file, I can get some information. See the following image:

zhDlRCe.png

How can I get this kind of information programmatically?

Thanks!
· Share on Twitter

Comments

  • Options
    peteypetey Posts: 2,358 New member
    You can get most of the details using this:
    EXEC master..sqlbackup '-sql "RESTORE SQBHEADERONLY FROM DISK = [<your backup file name>]"'
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
    · Share on Twitter
Sign In or Register to comment.