Options

RESTORE SQBHEADERONLY command

KayEKayE Posts: 4 New member
in SQL Backup
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
Tagged:
· Share on Twitter

Answers

  • Options
    RichardLRichardL Posts: 417 Gold 4
    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. 
    Customer Support
    Redgate Software
    · Share on Twitter
  • Options
    KayEKayE Posts: 4 New member
    Thanks Richard, I have lodged a ticket as requested.
    · Share on Twitter
Sign In or Register to comment.