数据库服务器移至新的数据库服务器后要做的步骤

问题描述：

我需要帮助.我们当前的SQL Server(2008)移至新的db sql server(2012)，这意味着所有数据库均已从旧sql服务器移至新sql服务器.

I need help. Our current SQL server (2008) moved to new db sql server (2012) , means all databases got moved from old sql server to new sql server.

旧数据库服务器 = ROSDC05 \ ROSDC05

old db server = ROSDC05\ROSDC05

新的数据库服务器 = ROSDC30 \ ROSDC30

new db server = ROSDC30\ROSDC30

因此，我创建了SQL别名"SQL2012"，通过cliconfg实用程序将其指向新的数据库服务器并进行IISreset，还执行了服务器重启

So, i created sql alias "SQL2012" pointing it to new db server from cliconfg utility and did IISreset, also performed server reboot

但是当我转到Central Admin时，它仍显示我旧的数据库服务器名称.另外，当我运行命令以查看哪个数据库实例正在运行时，它会显示旧的数据库服务器名称.我想念什么吗?请参阅所附的屏幕截图

But when i go to Central Admin, it is still showing me old db server name. Also, when i run a command to see which db instance is running, it is showing old db server name. Am i missing something? Please see the attached screenshots

请帮助做什么，以便它可以显示新的数据库服务器名称.我还测试了testdbconn.udl文件，新的别名SQL2012也显示在该udl文件中，但未在CA中显示.

Please help what to do so that it can show the new db server name. I also tested testdbconn.udl file and new alias SQL2012 is showing up as well in that udl file but not in CA.

谢谢

Chirag Shukla

chirag

答

嗨

请分步检查场景

请记住，如果您有多个SP服务器(WFE，APP等)，则应使用新的别名对其全部进行配置

Keep in mind that if you have multiple SP servers ( WFEs, APPs,... ) you should configure them all with the new alias

数据库服务器移至新的数据库服务器后要做的步骤

相关推荐