How do I relocate the SQL Sentry database?

avatar image By swordfish 16 asked Sep 26, 2012 at 08:47 PM
more ▼
(comments are locked)
10|5000 characters needed characters left

1 answer: sort voted first

Moving the SQL Sentry Database to a new SQL Server instance is a straightforward process. Following are the steps required to accomplish this:

  1. Retrieve the instance name for the new SQL Server by running SELECT SERVERPROPERTY('SERVERNAME') against it. Your license key is based on this instance name.

  2. Login to the Customer Portal.

    a. At the bottom of the portal, you will see the Licenses section. Select the license you would like to modify from the Perpetual Licenses list on the left.

    b. Now look for the Update Server Name section. Enter the server name from Step 1, as well as the reason for making this change.

    c. Click the Update button.

    d. Directly below this form, you will see a License Key form. Choose to either email the new key or copy it to the clipboard.

  3. Once you have received the new key, shut down all SQL Sentry Clients and Monitoring services.

  4. Perform a full backup of the SQL Sentry Database.

  5. Detach the SQL Sentry Database.

  6. Move the associated data and log files.

  7. Attach the SQL Sentry Database to the new server.

  8. Once the SQL Sentry Database has been attached, run the Service Configuration utility (located in the SQL Sentry installation directory on the server hosting the SQL Sentry monitoring service) to point the monitoring service to the new location for the SQL Sentry database.

  9. Open the SQL Sentry Client on any machine with a Monitoring service. After failing to locate the SQL Sentry Database, the Specify the SQL Sentry Database window should appear. Enter the new location of the SQL Sentry Database. The SQL Sentry Client will alert you that it needs to be restarted to connect to the new SQL Sentry Database. On restarting, you will be asked for the new license key.

  10. After successfully applying the license and starting the SQL Sentry Client, you may start the SQL Sentry Monitoring service on that machine.

  11. Repeat steps 8 and 9 on any other machines with SQL Sentry Monitoring services. You will not be asked for the license again, however.

  12. You may now start any other SQL Sentry Client and enter the new SQL Sentry Database location when asked.

  13. Don't forget to setup SQL Sentry Database maintenance on the new server.

Note: To remove an old server from the Connection List so that you will no longer be prompted about it when opening the SQL Sentry Client:

  1. Select the Server Name of the server you would like to remove in the “Please Specify the Server Name” drop-down list, and press Shift + Delete.

  2. The new server should now be the only one listed in the drop-down list. Use the Connect command and connect to the new installation.

The next time you open the Client it will automatically connect to the new installation.

avatar image By James Holden ♦ 1.6k answered Sep 26, 2012 at 08:52 PM
more ▼
(comments are locked)
10|5000 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 4.2 MB each and 8.4 MB total.