locked
R2 Migration Question about SQL RRS feed

  • Question

  • 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.

    Thanks
    Friday, February 13, 2009 4:13 AM

All replies

  • 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
    Friday, February 13, 2009 12:27 PM
    Moderator