Compresses, encrypts, secures and monitors SQL Server backups.
Moderators: JonathanWatts, Chris Auckland, eddie davis, Colin Millerchip, Brian Harris, james.billings, RBA, petey
When I hover my mouse over a sqb file, I can get some information. See the following image:
How can I get this kind of information programmatically?
- Posts: 29
- Joined: Mon Apr 12, 2010 8:21 pm
You can get most of the details using this:
- Code: Select all
EXEC master..sqlbackup '-sql "RESTORE SQBHEADERONLY FROM DISK = [<your backup file name>]"'
SQL Backup Consultant Developer
Associate, Yohz Software
- SQL Backup goodies under the hood, updated for version 7
- 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 1 guest