Moving the base monitor db

SQL Server performance monitoring and alerting

Moderators: eddie davis, priyasinha, Adam, chriskelly, Chris Lambrou, Chris Spencer

Moving the base monitor db

Postby Random Lengths » Wed Jan 11, 2012 5: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: 28
Joined: Mon Sep 29, 2008 11:02 pm
Location: Eugene, OR

Postby priyasinha » Wed Jan 11, 2012 6: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: 532
Joined: Wed Jan 03, 2007 5:02 pm

Return to SQL Monitor 2

Who is online

Users browsing this forum: No registered users and 0 guests