如何创建sql 2005的新实例 [英] how to create a new instance of sql 2005

问题描述

如何在Windows XP中创建sql 2005的新实例.

how to create a new instance of sql 2005 in windows xp.

does it have any disadvantage?

推荐答案

创建SQL Server新实例"的唯一方法是安装新副本，并为其提供新的SQL Server.姓名.然后，您可以连接到该服务器，而不是原始服务器.

但是，这不一定是一个好主意-大量的SQL Server实例可能意味着您最终会在重复的数据库中复制数据并在错误的副本上更改了数据.

不过，如果现有服务器工作过度，它可以加快数据库访问速度-但是服务器场可能是更好的解决方案.

The only way to create a "new instance" of SQL server is to install a new copy, and give it a new SQL Server name. You can then connect to that server instead of the original.

It''s not necessarily a good idea though - proliferating SQL server instances can mean that you end up with databases being duplicated and data being changed on the wrong copy.

It can speed up DB access though, if your existing server is overworked - but a server farm might be a better solution.

这篇关于如何创建sql 2005的新实例的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！