How to get this kind of information programmatically?

Compresses, encrypts, secures and monitors SQL Server backups.

Moderators: JonathanWatts, Chris Auckland, eddie davis, Colin Millerchip, Brian Harris, james.billings, RBA, petey

How to get this kind of information programmatically?

Postby ogrishman » Fri Mar 15, 2013 3:59 am

When I hover my mouse over a sqb file, I can get some information. See the following image:

Image

How can I get this kind of information programmatically?

Thanks!
ogrishman
 
Posts: 29
Joined: Mon Apr 12, 2010 8:21 pm

Postby petey » Sat Mar 16, 2013 8:20 am

You can get most of the details using this:

Code: Select all
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 7
petey
 
Posts: 2234
Joined: Sun Apr 24, 2005 12:34 pm


Return to SQL Backup 7

Who is online

Users browsing this forum: No registered users and 0 guests