Moving OperationsManager Database
Hello, We have move the OperationsManager database. BUT SQL Server remains on the RMS with SharePoint and SCCM Dashboard for SCOM. Should I move all of them as well? Thanks, DomSystem Center Operations Manager 2007 / System Center Configuration Manager 2007 R2 / Forefront Client Security / Forefront Identity Manager
July 8th, 2011 2:08am

If the move was succesful you can just leave the others be. It's not a best practice to use your RMS as an SQL server so if you have the ability I suggest to move them to free up resources on the RMS but you're not obliged to do so. It's doing common things uncommonly well that brings succes.
Free Windows Admin Tool Kit Click here and download it now
July 8th, 2011 5:52am

It is entirely up to you. If they dont bother you and the rms has enogh resources you can leave them as is. If you want to move them, you can do so.Bob Cornelissen - BICTT (My BICTT Blog) - Microsoft Community Contributor 2011 Recipient
July 8th, 2011 6:51am

Hi Dom Would agree that they shouldn't really be on the same box as the RMS although specification of the hardware and the number of agents you have might mean that it works for you (although I guess ultimately it hasn't as you have moved the OpsMgr database elsewhere). My concern on removing SQL is that you also have SharePoint and the SCCM dashboard installed. You'll need to make sure that they are "moved" successfully to another SQL Server first. Have you considerer moving the RMS to a new server and then leaving SQL \ SharePoint on this server? Cheers GrahamView OpsMgr tips and tricks at http://systemcentersolutions.wordpress.com/
Free Windows Admin Tool Kit Click here and download it now
July 8th, 2011 7:33am

Good Ideas thanks everybody DomSystem Center Operations Manager 2007 / System Center Configuration Manager 2007 R2 / Forefront Client Security / Forefront Identity Manager
July 8th, 2011 11:34am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics