Forum Discussion

bordio27's avatar
bordio27
Level 4
5 years ago

How generating bch for SQL restore retrieves database informations

Hi, I'm trying to make a Powershell script to automate the restore process of the SQL Server databases It's clear for me how to do it, but the only things I can't get are the SQL path informations ...
8.1.2
windows server 2012
  • Michal_Mikulik1's avatar
    Michal_Mikulik1
    5 years ago

    Hello,

    you will have to "play" with bpflist command output. It returns these values (MSSQL_METADATA_FILES, MSSQL_MEDATADA_LOGFILE). For example:

    bpflist -backupid <client>_1571795399 -rl <rl> -option GET_ALL_FILES

    Note that this command is available on NetBackup servers only, not clients.

    Regards

    Michal

Michal_Mikulik1's avatar
Michal_Mikulik1
Moderator

Hello,

you will have to "play" with bpflist command output. It returns these values (MSSQL_METADATA_FILES, MSSQL_MEDATADA_LOGFILE). For example:

bpflist -backupid <client>_1571795399 -rl <rl> -option GET_ALL_FILES

Note that this command is available on NetBackup servers only, not clients.

Regards

Michal

bordio27's avatar
bordio27
Level 4
5 years ago

Thank you Michal, that's what I need

Do you know if there's a way to have bpflist executable on a client?

db