How can we help you today? How can we help you today?

Correct Syntax for Restoring sQBHeaderOnly with Password

I am having issues with the syntax for sqbheaderonly in SQL SERVER Managment Studio 
EXECUTE master..sqlbackup '-SQL "RESTORE SQBHEADERONLY FROM DISK = ''c:\backups\FULL_DB001_superbill_24305_prod_20140219_200928_encr.sqb''With Password='''teest'''"'

Can someone please tell me what I am missing.

thanks
pamozer
0

Comments

2 comments

Sort by
  • pamozer
    Syntax error: 'teest''' after 'c:\backups\FULL_DB001_superbill_24305_prod_20140219_200928_encr.sqb WITH PASSWORD ='
    pamozer
    0
  • petey 
    EXECUTE master..sqlbackup '-SQL "RESTORE SQBHEADERONLY FROM DISK = ''c:\backups\FULL_DB001_superbill_24305_prod_20140219_200928_encr.sqb'' WITH PASSWORD = ''teest'' "'
    or 
    EXECUTE master..sqlbackup '-SQL "RESTORE SQBHEADERONLY FROM DISK = [c:\backups\FULL_DB001_superbill_24305_prod_20140219_200928_encr.sqb] WITH PASSWORD = [teest] "'
    petey
    0

Add comment

Please sign in to leave a comment.