SUMMARY
Agent line item to allow SQL DB restore to file instead of mounting directly to SQL DB instance
ISSUE
Agent line item to allow SQL DB restore to file instead of mounting directly to SQL DB instance
RESOLUTION
This will allow to restore files to the client without creating database.
User will be able to create database with attach files using SQL Server Management.
TASKS
Add setting in agent master.ini
[SQL Server]
IsAlternateRestore=True
Then specify the path on UI where to restore and db name:
Select client to restore;
Restore Database name: example "altdb"
Restore Path: E:\alternatepath
Once restore completes user will be able to restore files to the database instance as needed per SQL Management Studio