So we have an existing OCS RTM enteprise pool to a backend SQL 2005 Cluster. I would like to attempt a side by side migration by creation a new pool but my main question is, can I point to the existing SQL Instance where the RTM databases are? Ideally, I would like to create a second instance on the SQL Cluster but I'm not sure how to.
I would love to hear from anyone who has completed a side by side migration where you created a new SQL Instance on your backend cluster for the R2 databases.
You will have to create a new instance on the SQL server because R2 uses the same DB names as R1. You accomplish this by re-running the SQL server setup process and specifying an instance name when prompted during the installation.Mike Stacy | Evangelyze Communications | http://www.evangelyze.net/cs/blogs/mike