Creating a Second Set of Databases as a Named Instance 1

[JohnBates]

hi all,

On my 2005 Standard Edition server, I'm considering adding another group of databases. They would have the same name as the existing databases on this server. Is this possible if I simply create a named instance and create the databases there?

I don't need another license, right?
Can I do this without using clustering - I don't want to configure clustering.

Assuming the server can support the additional databases, is this advisable?

Thanks, John

 

[JayKusch]

Yes ... you are correct on all counts.

I "beleive" you can create 1 "Default" instance of SQL Server 2005 and 15 "Named" (may even be more but you are at least covered".

You do not need a second license for the server (clustering you would have to).

You CAN have the same DB names in each instance.

As a side note, set your second instance to use port 1434 (since you default instance is using 1433 unless you set it manually to a different port).

I have several Production server with multiple instances.

Just make sure to keep note on who you are allocating resources (Mem/Disc and to some extent CPU). You need to balance them between your instances so that one instance kills the performance on the others.

Hope this helps!

Thanks

J. Kusch

 

[JohnBates]

Yes, that helps a lot, Jay. Thanks.


Hope would I reference a table belong to a non-default instance named "Test"?

To select * from Table1 in Db1 in the Test instance...for example?

John

 

[JayKusch]

Select * from [ServerName\InstanceName].DBName.[dbo].Table

Thanks

J. Kusch

 

[SQLWilts]

John,
If you want to query tables across instances, it works the same as if you are going across servers - dont forget to add in your instance as a linked server...