PowerProtect Data Manager 19.16 File System User Guide

Performing DR for Microsoft SQL application data

The Microsoft SQL Server application agent needs a Microsoft SQL Server service to be running in single-user mode to restore the system database (master database). Since the File System agent on Windows does not backup the SQL server system database, the user needs to perform the below steps for an end-to-end DR solution for the SQL system database and user database in Windows.

1. Perform the BMR restore of Windows. See Performing bare-metal recoveryfor more information.
2. Mount the Microsoft SQL Server installation media in Microsoft Windows and run the following command. This rebuilds the Microsoft SQL Server System database.

   Setup /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=MSSQLSERVER_2017 /SQLSYSADMINACCOUNTS=bmrtestdomain\administrator /SAPWD=Password

   NOTE:Select the Microsoft SQL Server version according to the SQL version instance installed and configured. The above command was for the Microsoft SQL Server version 2017.
3. Start the Microsoft SQL Server instance in single-user mode and using the Microsoft SQL Server application agent, restore the Microsoft SQL server system database (master database). There are many ways, the user can start the Microsoft SQL Server instance in single-user mode. Perform the following steps to configure Microsoft SQL Server 2017 instance in a single-user mode.
   1. Start the SQL Server Configuration Manager.
   2. Right-click on the SQL server instance and select Properties.
   3. In the Startup parameters tab, enter -m in the Specify a startup parameter field and click Add.
   4. Click Apply and Ok.
   5. Restart the SQL server instance.
   The following example describes restoring the System DB through CLI:

   C:\Program Files\DPSAPPS\MSAPPAGENT\bin>ddbmsqlrc.exe  -a NSR_DFA_SI_DD_HOST=192.162.1.1 -a NSR_DFA_SI_DD_USER=PLC_SQL_62-ppdm1461-f1cad -a NSR_DFA_SI_DEVICE_PATH=/PLC_SQL_62-ppdm1461-f1cad/PLCTLP-fddae07f-d1c3-497e-8b7c-a8d90f270812 -a "NSR_DFA_SI_DD_LOCKBOX_PATH=C:\Program Files\DPSAPPS\common\lockbox" -c bmrtestvm-62.bmrtestdomain.com -a "SKIP_CLIENT_RESOLUTION=TRUE" -f -t "06/03/2022 08:08:36 PM" -S normal MSSQL$MSSQLSERVER_2017:master

4. Start the Microsoft SQL Server instance in multiuser mode. Use the Microsoft SQL Server application agent to restore the msdb and model database.
   1. Start the SQL Server Configuration Manager.
   2. Right-click on the SQL server instance and select Properties.
   3. In the Startup parameters tab, select -m from the Existing parameters field and click Remove.
   4. Click Apply and Ok.
   5. Restart the SQL server instance.
   See PowerProtect Data Manager Microsoft SQL Server User Guide follow the steps to recover the Microsoft SQL Server msdb and model database.

   The following example describes restoring the msdb database through CLI:

   ddbmsqlrc.exe  -a NSR_DFA_SI_DD_HOST=192.168.1.1 -a NSR_DFA_SI_DD_USER=PLC_SQL_62-ppdm1461-f1cad -a NSR_DFA_SI_DEVICE_PATH=/PLC_SQL_62-ppdm1461-f1cad/PLCTLP-fddae07f-d1c3-497e-8b7c-a8d90f270812 -a "NSR_DFA_SI_DD_LOCKBOX_PATH=C:\Program Files\DPSAPPS\common\lockbox" -c bmrtestvm-62.bmrtestdomain.com -a "SKIP_CLIENT_RESOLUTION=TRUE" -f -t "06/03/2022 08:08:36 PM" -S normal MSSQL$MSSQLSERVER_2017:msdb

   The following example describes restoring the model database through CLI:

   ddbmsqlrc.exe  -a NSR_DFA_SI_DD_HOST=192.168.1.1 -a NSR_DFA_SI_DD_USER=PLC_SQL_62-ppdm1461-f1cad -a NSR_DFA_SI_DEVICE_PATH=/PLC_SQL_62-ppdm1461-f1cad/PLCTLP-fddae07f-d1c3-497e-8b7c-a8d90f270812 -a "NSR_DFA_SI_DD_LOCKBOX_PATH=C:\Program Files\DPSAPPS\common\lockbox" -c bmrtestvm-62.bmrtestdomain.com -a "SKIP_CLIENT_RESOLUTION=TRUE" -f -t "06/03/2022 08:08:36 PM" -S normal MSSQL$MSSQLSERVER_2017:model

5. Restore the user database using the Microsoft SQL Server application agent.
   See PowerProtect Data Manager Microsoft SQL Server User Guide follow the steps to recover the Microsoft SQL Server user database.