Ask the Community
Groups
How to restore the master database with the legacy SQL agent - Connect IT Community | Kaseya
<main> <article class="userContent"> <h2 data-id="summary"><strong>SUMMARY</strong></h2> <p>How to restore the master database with the legacy SQL agent</p> <h2 data-id="issue"><strong>ISSUE</strong></h2> <p></p> <h3 data-id="purpose">Purpose</h3> <p>Directions for restoring the master database for SQL Server 2000 using Unitrends legacy SQL agent.</p> <h3 data-id="applies-to">Applies To</h3> <p>Windows agent and SQL Server 2000</p> <h3 data-id="description">Description</h3> <p>Need to restore master database.</p> <h3 data-id="resolution">Resolution</h3> <ol><li>Go to SQL Enterprise Manager and stop the instance.</li> <li>Open Registry Editor to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\Parameters</li> <li>Rename SQLArg2 to SQLArg3.</li> <li>Rename SQLArg1 to SQLArg2.</li> <li>Rename SQLArg0 to SQLArg1.</li> <li>Create a new String value called SQLArg0 with a value of –m</li> <li>Use SQL Enterprise Manager to start the instance.</li> <li>Once the instance is started, close Enterprise Manager and any other SQL UIs.</li> <li>Used the Registry Editor to delete SQLArg0 and then revert the names of the other arguments to their prior names.</li> <li>Start the Unitrends Legacy SQL Server Agent to queue the restore of the master database and then immediately exit the agent UI.</li> </ol> </article> </main>