Redgate Monitor 14

Moving the data repository to a different machine

If you want to move the Redgate Monitor Data Repository (a database that stores all configuration and monitoring data), follow these steps:

  1. Stop the Base Monitor service.

    To do this, go to Services (select Start > Run, enter services.msc and click OK) and stop Redgate Monitor Base Monitor.

  2. In your SQL Server management tool, back up your current Data Repository database and then restore it to your preferred location. If you did not change the default name when installing, the Data Repository database will be called RedgateMonitor.
  3. Edit the Redgate Monitor configuration file to update the connection string that locates the Redgate Monitor database.
    Navigate to the folder you specified for the configuration file during installation.

    Default location:

    %ProgramData%\Red Gate\Redgate Monitor, by default C:\ProgramData\Red Gate\Redgate Monitor.
    %ProgramData% is often a hidden folder.
  4. Open RedGate.Monitor.BaseMonitor.exe.settings.config in a text editor or XML editor. The Data Repository database is specified in the <connectionStrings> section near the end of the file:

    <connectionStrings>
        <add name="DataConnectionString" connectionString="Data Source=MACHINENAME\SQLInstancename;Initial Catalog=RedgateMonitor;Integrated Security=True;Application Name=&quot;Redgate Monitor - Repository&quot;"/>
    </connectionStrings> 

    By default, this entry points to the Data Repository database you specified during installation. To move the Data Repository to a different database, edit this entry to point to a different Data Source (SQL Server instance) and Catalog (database name). For example:

    <add name="DataConnectionString" connectionString="Data Source=SECUREMACHINENAME\MyInstance;Initial Catalog=RedgateMonitor;Integrated Security=True;Application Name=&quot;Redgate Monitor - Repository&quot;"/>
  5. Save the configuration file.
  6. Restart the Redgate Monitor Base Monitor service.
  7. Launch Redgate Monitor in your browser. To check that your change has been made, go to the About page (Configuration > About > Configuration information). Under Base Monitor, ensure that the settings for Database have been updated to the new database name.

Didn't find what you were looking for?