Red Gate forums :: View topic - Moving the base monitor db
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Monitor 2
SQL Monitor 2 forum

Moving the base monitor db

Search in SQL Monitor 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
Random Lengths



Joined: 29 Sep 2008
Posts: 23
Location: Eugene, OR

PostPosted: Wed Jan 11, 2012 5:56 pm    Post subject: Moving the base monitor db Reply with quote

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?

Dan
Back to top
View user's profile Send private message
priyasinha



Joined: 03 Jan 2007
Posts: 530

PostPosted: Wed Jan 11, 2012 6:45 pm    Post subject: Reply with quote

Hi Dan,

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

Thanks,
Priya
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group