如何在Sql Server 2012或2008 R2中创建5个不同的实例。 [英] How to create 5 different instances in Sql Server 2012 or 2008 R2.?

问题描述

我只是想在我们的MS Sql Server 2012中创建单独的数据库环境，如开发，测试和生产等..但是无法弄清楚确切的方法。



我做了一些研究，根据微软的以下链接，它说..



我们可以创建多达50个实例sql server，但我不知道如何创建它们。



http://msdn.microsoft.com/en-us/library/ms143432.aspx [ ^ ]





注意：

1.一些链接建议在安装sql server时选择命名实例而不是默认实例，但这不会创建5个实例。



2.我已经尝试通过在sql server 2中导航到View-> Register Server来注册新服务器008 R2，但没有出现。



3.我不是要求添加登录/数据库，而是要求一个新的独立环境应该与其他实例完全不同。



提前谢谢。

I just want to create separate database environments like Development, Testing and Production etc.. in our MS Sql Server 2012, but couldn't able to figure out 'the exact method of doing it'.

I did some research and according to the below link from microsoft, it says..

we can create upto 50 instances in sql server, but i don't know how to create them.

http://msdn.microsoft.com/en-us/library/ms143432.aspx[^]


Note:
1. some of the links suggests to select "Named Instance" instead of "Default Instance" while installing the sql server, but that doesn't creates 5 instances.

2. I already tried to register a new server by navigating to View->Register Server, in sql server 2008 R2, but nothing is appearing.

3. I am not asking about adding Logins/Databases but a new separate environment which should be entirely different from the other instance.

Thanks in advance.

推荐答案

阅读： http://stackoverflow.com/questions/3128768/how-to-create-instance-in-sql-server- 2008 [ ^ ]



http://www.ehow.com/how_5054568_create-new-instance-sql-server.html [ ^ ]

Read this : http://stackoverflow.com/questions/3128768/how-to-create-instance-in-sql-server-2008[^]

http://www.ehow.com/how_5054568_create-new-instance-sql-server.html[^]

这篇关于如何在Sql Server 2012或2008 R2中创建5个不同的实例。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！