数据库服务器移至新的数据库服务器后要做的步骤 [英] Steps to do after db server moved to new db server
问题描述
我需要帮助.我们当前的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 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
这篇关于数据库服务器移至新的数据库服务器后要做的步骤的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!