Hope someone can help me answer my DBA's questions.
"We are in the process of creating the plan for the move to SQL
2005. We are now leaning more towards a flash conversion of all the SQL databases to
SQL 2005 rather than an application by application phased in approach. We currently have a
SQL 2005 instance loaded to the ' ServerName'
server with the original default instance of sql200 still in use. Since the sql2005 server is considered a named instance it currently must be used by referring to the full instance name of ‘ServerName\
I have just checked online and cannot find any valid way to rename an existing sql server, which for our current situation would be ideal. My original idea was to connect all the databases to the
SQL 2005 instance, have the SQL 2000 software uninstalled, and rename the named sql2005 instance to websql so that all the applications will run without modification. I have just found that this will not be possible.
According to everything I found, the sql server cannot be renamed. The software must be uninstalled and reinstalled with the desired name. Our plan of the flash conversion requires that we list the possible steps to accomplish this conversion
based on the knowledge that we can’t rename the sql server.
Can you give us your take on
View Complete Post