RESTORE SQBHEADERONLY command

KayE

Hello,

Is it possible to get the database name of backup files use SQBHEADERONLY?

I'm working on a script that will restore all databases that will be restored in folder.

Thanks,
Kay

RichardL

Hi @KayE

Thanks for your post. 

I've sent you a message but have just discovered that yes this is possible to do. 
It provides a lot of information including "Server name" and "Database name" in the query result (when running the extended stored procedure). 

I hope this helps. 

Kind regards

Richard Lynch. 

KayE

Thanks Richard, I have lodged a ticket as requested.