Moving the base monitor db

Monitor, diagnose and receive alerts to problems across your SQL Servers.

Moving the base monitor db

Postby Random Lengths » Wed Jan 11, 2012 4:56 pm

I have only one db server and another IIS server, so I have the Monitor db on the primary server with the server and databases being monitored, but connected to the IIS web server.

Now, I've installed SQL Server Express on the IIS server. What is the best method of moving the db to the other server, so I can keep my config, and history? Dettach, re-attach? Re-install SQLMonitor, then SQL Compare it over?

Random Lengths
Posts: 34
Joined: Mon Sep 29, 2008 10:02 pm
Location: Eugene, OR

Postby priyasinha » Wed Jan 11, 2012 5:45 pm

Hi Dan,

You can follow the steps in this article. You can either backup/ restore or Detach/ Reattach, whatever is easier for you.

Posts: 535
Joined: Wed Jan 03, 2007 4:02 pm

Return to SQL Monitor Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests