August 11, 2014 at 11:07 am
I am planing to upgrade sql 2005 to sql 2008 R2 but would like to do as a separate instance in the same physical box due to the server constraints i have. Is it possible to install SQL 2008 with some temporary name and then switch back to my primary name?
so I have 2005 server with name "XYZ" whiich is a default instance and now i want to install SQl 2008 R2 with a named instance "ABC" so that i can configure everything by looking at "XYZ" and once comfortable i want to make "ABC" as "XYZ" and delete the 2005 instance.
August 11, 2014 at 8:22 pm
Tara-1044200 (8/11/2014)
I am planing to upgrade sql 2005 to sql 2008 R2 but would like to do as a separate instance in the same physical box due to the server constraints i have. Is it possible to install SQL 2008 with some temporary name and then switch back to my primary name?so I have 2005 server with name "XYZ" whiich is a default instance and now i want to install SQl 2008 R2 with a named instance "ABC" so that i can configure everything by looking at "XYZ" and once comfortable i want to make "ABC" as "XYZ" and delete the 2005 instance.
Unfortunately "no" you cannot rename a "named instance" to the "default" instance
So default instance: "CUSTOMERSERVER"
* contains old db 2005
So named instance: "CUSTOMERSERVER\SQL2008R2_TEST"
* contains migrated db 2008r2
Not possible re-name named instance to default: "CUSTOMERSERVER"
* Attempt to RENAME from CUSTOMERSERVER\SQL2008R2_TEST
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply