Ask the Community
Groups
SQL DB alt recovery to flat file - Connect IT Community | Kaseya
<main> <article class="userContent"> <h2 data-id="summary"><strong>SUMMARY</strong></h2> <p>Agent line item to allow SQL DB restore to file instead of mounting directly to SQL DB instance</p> <h2 data-id="issue"><strong>ISSUE</strong></h2> <p>Agent line item to allow SQL DB restore to file instead of mounting directly to SQL DB instance</p> <h2 data-id="resolution"><strong>RESOLUTION</strong></h2> <p>This will allow to restore files to the client without creating database. <br>User will be able to create database with attach files using SQL Server Management.</p> <h2 data-id="tasks"><strong>TASKS</strong></h2> <p>Add setting in agent master.ini<br><br>[SQL Server]<br>IsAlternateRestore=True<br><br>Then specify the path on UI where to restore and db name: <br>Select client to restore; <br>Restore Database name: example "altdb"<br>Restore Path: E:\alternatepath<br><br>Once restore completes user will be able to restore files to the database instance as needed per SQL Management Studio</p> </article> </main>