Red Gate forums :: View topic - How to get this kind of information programmatically?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  | Register 
Go to product support center
SQL Backup 7
SQL Backup 7 forum

How to get this kind of information programmatically?

 Search in SQL Backup 7 forum
Post new topic   Reply to topic
Jump to:  
Author Message
ogrishman



Joined: 12 Apr 2010
Posts: 20
PostPosted: Fri Mar 15, 2013 3:59 am    Post subject: How to get this kind of information programmatically? Reply with quote
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?

Thanks!
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2215
PostPosted: Sat Mar 16, 2013 8:20 am    Post subject: Reply with quote
You can get most of the details using this:

Code:
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
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
 You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group