SQL DB alt recovery to flat file

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

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Contact us