I have a server with a default instance and 2 named instances of SQL Server 2005 standard installed. This is a mission critical production server that cannot be restarted during normal business hours.
我有一个服务器,默认实例和安装了SQL Server 2005标准的2个命名实例。这是一个关键任务生产服务器,在正常工作时间内无法重新启动。
Will uninstalling the two named instances of SQL Server 2005 require a reboot or put the server in a state that may cause issues with the default instance of SQL Server 2005 until it's rebooted?
卸载SQL Server 2005的两个命名实例是否需要重新启动或将服务器置于可能导致SQL Server 2005的默认实例出现问题的状态,直到重新启动为止?
2 个解决方案
#1
This would probably get a better answer at serverfault.com.
这可能会在serverfault.com上得到更好的答案。
I'm not sure how much it would help perf, if SQL isn't getting hit it doesn't do much. You could probably get away with uninstalling, but then again when in surgery bad things happen. I've never killed SQL server uninstalling an instance, but I have killed the client tools. I would take one of the following approaches:
我不确定它会对perf有多大帮助,如果SQL没有被击中它没有做太多。你可能可以逃脱卸载,但在手术中又发生了不好的事情。我从来没有杀过SQL服务器卸载一个实例,但我杀死了客户端工具。我会采取以下方法之一:
a) First, backup and drop all the databases to reclaim the disk space. Then stop disable the services for the named instances. The binaries will still be there, but they aren't too large and will be sitting idle.
a)首先,备份并删除所有数据库以回收磁盘空间。然后停止禁用命名实例的服务。二进制文件仍然存在,但它们不会太大而且会闲置。
b) Better long-term plan if you can source the hardware is to setup a new de novo box and drop a clean SQL instance over there, then port the live server over. Really not too painful. Then repurpose old box as is fit.
b)更好的长期计划,如果您可以提供硬件来设置一个新的de novo框并在那里放一个干净的SQL实例,然后移动实时服务器。真的不太痛苦。然后重新调整旧盒子。
#2
Is there a critical reason why you need to uninstall named instances. Can you just ignore them?
是否有一个关键原因需要卸载命名实例。你能忽略它们吗?
EDIT: the answer is yes you can uninstall via add/remove programs
编辑:答案是肯定的,您可以通过添加/删除程序卸载
Rebooting doesn't occur
不会重新启动
An article which might apply to your situation:
一篇可能适用于您的情况的文章:
#1
This would probably get a better answer at serverfault.com.
这可能会在serverfault.com上得到更好的答案。
I'm not sure how much it would help perf, if SQL isn't getting hit it doesn't do much. You could probably get away with uninstalling, but then again when in surgery bad things happen. I've never killed SQL server uninstalling an instance, but I have killed the client tools. I would take one of the following approaches:
我不确定它会对perf有多大帮助,如果SQL没有被击中它没有做太多。你可能可以逃脱卸载,但在手术中又发生了不好的事情。我从来没有杀过SQL服务器卸载一个实例,但我杀死了客户端工具。我会采取以下方法之一:
a) First, backup and drop all the databases to reclaim the disk space. Then stop disable the services for the named instances. The binaries will still be there, but they aren't too large and will be sitting idle.
a)首先,备份并删除所有数据库以回收磁盘空间。然后停止禁用命名实例的服务。二进制文件仍然存在,但它们不会太大而且会闲置。
b) Better long-term plan if you can source the hardware is to setup a new de novo box and drop a clean SQL instance over there, then port the live server over. Really not too painful. Then repurpose old box as is fit.
b)更好的长期计划,如果您可以提供硬件来设置一个新的de novo框并在那里放一个干净的SQL实例,然后移动实时服务器。真的不太痛苦。然后重新调整旧盒子。
#2
Is there a critical reason why you need to uninstall named instances. Can you just ignore them?
是否有一个关键原因需要卸载命名实例。你能忽略它们吗?
EDIT: the answer is yes you can uninstall via add/remove programs
编辑:答案是肯定的,您可以通过添加/删除程序卸载
Rebooting doesn't occur
不会重新启动
An article which might apply to your situation:
一篇可能适用于您的情况的文章: