Moving the Ops Mgr DB
After much delay, uncertainty, fear and paranoia, I've finally moved our Ops Manager 2007 (SP1) DB to a new 64-bit HP behemoth server.
I can say that it went exactly as advertised. I chose not to delete the original DB, but merely backed it up and than took it offline. Once I'm sure things are happy, healthy and stable I'll delete it. Paranoia can be a pain, but I'll take it in cases like this.
The only surprise was the length of time it took to restore the DB. After copying it over I assumed that restoration would be far faster than the backup from the original server, but if anything it took longer to restore the DB to the new server. I'm not quite sure why this would be, but intend to discuss it with our SQL guru when I get the chance.