We currently have a three server topology for our FCS setup. I have a SQL 2005 Enterprise box that contains the Collection server, Collection Database, Reporting server and Reporting database. I have been asked to move all these to
a SQL 2005 Standard box.
I have found some documentation on the migration process but I was wondering if there is a particular order I need to move these components ? Also the reporting database has partitions in it and those are unsupported in the standard edition of SQL so I am
unsure how to migrate this database? Also how do I get the PCs to point to the new server and report their status.
If anyone has any tips to share on migration let me know. I am new to the FCS product and have not even finished the rollout at our college of 1600 PCs.
I can help you a bit on the way in trems of redirecting the clients to the new box yhou have to reinstall the MOM agent because it only reads it's config information at setup. However it sounds worse that it might be. Do you have SCCM or something similar?
check out my blog post about migrating clients. It's about migrating to another AD forest but you can just edit the scripts to fit your need.