February 17, 2005 at 10:39 am
How do you create multiple SQL instances on the same SQL server?
February 17, 2005 at 10:49 am
It's just another install of SQL Server.
for help refer to BOL-->Installing SQL Server-->Instances-->How to install a named instance of SQL Server 2000 (setup).
..hope that helps.
February 17, 2005 at 10:54 pm
You just install the SQL Server again.
It will ask for a new instance name
for eg: Dinesh\QA
QA will be the instance. u can access the server Dinesh\QA
My Blog:
February 18, 2005 at 5:16 am
You may want to set the TCP port fo each instance you create. This gives more control over the connection parameters. Also ther is alimit of how many instances you can create.
February 18, 2005 at 10:29 am
I'm curious as to what the 'limit' of instances that can be created on a given physical server is. Please advise (I've just never thiought about this limit !) ...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
February 18, 2005 at 11:32 am
I believe the limit is 16.
The real question though is why have multiple instances.
There are some good reasons,
Different versions, during migration.
Multiple Test / Development
Active / Active clustering
But in general I haven't found any compelling reasons for them. There is a lot of overhead and additional manual management required.
KlK
February 18, 2005 at 11:38 am
thanks for the response on the max number of named instances per server ...
oh by the way here's the most important reason for multiple instances:
'to compete with Sybase and Oracle'
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply