Restore Mode through Registry Key

This section provides information about how to use the restore mode using registry key. This method restores the Filestream enabled database to the alternate instance (INS1_FSE).

After the backup is successful, add the registry key in the VSSWrap folder with the DWORD 32-bit value: WithoutPITNoAutoRecovery, and set the value to 1.

HKEY_LOCAL_MACHINE\SOFTWARE\Arcserve\Unified Data Protection\Engine\VSSWrap\

Follow these steps:

1. To restore the database to alternate instance, open the SqlRestore.ini file, and then change the folder locations as needed.
2. 
2. On the Agent, in the Restore page, select the database that you want to restore, and then click Next.
3. 
3. In the Restore Options screen, select Restore to alternative location and browse the instance.
4. 
5. To rename the Database Name, click the New Database Name text area and type the new name. For example, SFS_SFG is renamed as SFS_SFG_UDP.
6. Note: Under Alternative file location, a temp folder is selected. This location processes the restore of files to the location defined in the SqlRestore.ini file.
4. Verify if the settings are correct, and then click Finish to start the restore process.
5. 
6. The activity log displays the status of the restore along with the rename of the database.
7. 

In certain instances, the database still shows as restoring even after the job is successfully completed.

To remove the database from the restoring mode, do the following:

1. Right-click the database, and then select New Query.
2. The Window pops up and connects to the restored instance.
3. 
2. In the query window, run the following query.
3. RESTORE DATABASE [DATABASE NAME] WITH RECOVERY
4. 
5. The restoring mode is removed from the database.
6. Note: When the renaming of a database file is not successful while using the registry, the primary folder displays the new name, however, the database files such as MDF, NDF and LDF displays the original database name..
7. 
8.