PowerProtect Data Manager 19.15 Microsoft SQL Server User Guide

Perform disaster recovery from the Cloud Tier

The Microsoft application agent provides a command line tool to complete disaster recovery of save sets that are located in a Cloud Tier.

After an MTree is recovered according to the disaster recovery procedure described in Perform Microsoft SQL Server disaster recovery, you must restore the backup indexes from the Cloud Tier.

When the Microsoft application agent moves a backup to the cloud, the index files are maintained on the active tier. A copy of the index files is created and moved to the cloud tier for long-term retention.

After an MTree is restored during a disaster recovery, all the files that resided only on the active tier are lost and unavailable. Only the files that were moved to the cloud are available.

In this case, you must run msagentadmin administration with the --dr-recall or -M flag to restore the indexes.

After the indexes are recalled to the active tier, the data save sets for the same time range are also recalled unless you type n when prompted with Continue with the recall of the found save sets [y/n]. If you choose to not recall the save sets, you can manually recall the save sets later.

Type the msagentadmin administration command with the following syntax to recall the indexes to the active tier:

msagentadmin administration --dr-recall --ddhost "<DD_server_name>" --ddpath "<storage_unit_name_and_path>" --dduser "<DD_Boost_username>" --appID "mssql"

where:

--dr-recall

Specifies an operation to recall save sets for disaster recovery.

You can use the -M alias for the --dr-recall parameter.

--ddhost "<DD_server_name>"

Specifies the name of the DD server that contains the storage unit, to which you backed up the databases.

--ddpath "<storage_unit_name_and_path>"

Specifies the name and the path of the storage unit, to which you backed up the databases.

--dduser "<DD_Boost_username>"

Specifies the username of the DD Boost user.

--appID "mssql"

Specifies the application ID (namespace) to locate backups.

You can use the -n alias for the --appID parameter.

msagentadmin administration --dr-recall --tier --after 1481104962 --before 1481105533 --appID mssql --ddhost "10.70.102.111" --ddpath "/mt1" --dduser "ost" --confirm --client SQLX86.adesc.com --debug 9

msagentadmin administration --dr-recall --tier --after 1481104962 --before 1481105533 --appID mssql --confirm --config c:\temp\config_pp.txt --debug 9