Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

SQL Server Instances Expand / Collapse
Author
Message
Posted Monday, June 15, 2009 10:43 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, August 11, 2009 6:16 AM
Points: 8, Visits: 38
Can someone please explain what is multiple sql server instances? How can that be used in a single database?
Post #735438
Posted Monday, June 15, 2009 10:49 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Sunday, July 6, 2014 3:07 PM
Points: 2,242, Visits: 3,643
y_winny (6/15/2009)
Can someone please explain what is multiple sql server instances? How can that be used in a single database?

One database can be attached to only one instance.

To give an bird's eye view, You have one physical server over which you install multiple SQl Servers (each of which is called an instance). You create databases in these different instances.

Normally we create multiple instances of sql server only if we have multiple sql server versions.
Eg. one for sql server 2000, another for sql server 2005..

This link will give u more description on multiple instances.
http://msdn.microsoft.com/en-us/library/aa174516(SQL.80).aspx





Pradeep Singh
Post #735442
Posted Monday, June 15, 2009 11:00 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, August 11, 2009 6:16 AM
Points: 8, Visits: 38
I thought when you install a newer version of sql server and it overrides the older version on the PC. Can that be achieved when you already have sql 2000 and want to install sql 2005 without overriding the sql 2000 on the same pc?

Can you please give more example on multiple SQL Server instances?
Post #735451
Posted Monday, June 15, 2009 11:08 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Sunday, July 6, 2014 3:07 PM
Points: 2,242, Visits: 3,643
y_winny (6/15/2009)
I thought when you install a newer version of sql server and it overrides the older version on the PC. Can that be achieved when you already have sql 2000 and want to install sql 2005 without overriding the sql 2000 on the same pc?

Can you please give more example on multiple SQL Server instances?


yes that is possible. If you have a default instance of sql 2000 and you want to install sql 2005 as a seperate instance, it has to be a named instance (you provide a name to this instance). Both versions of sql can happily reside on one server with their own databases. you can check that out in services(click start->run->services.msc). you'll see seperate services for each instance for sql servers.
I hope u went through the msdn url i provided in earlier post.
here are some others.
http://www.mssqltips.com/tip.asp?tip=1048
http://technet.microsoft.com/hi-in/magazine/2006.03.sqlqa(en-us).aspx -- read from 2nd question there..





Pradeep Singh
Post #735453
Posted Tuesday, June 16, 2009 6:33 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, October 31, 2013 3:44 AM
Points: 314, Visits: 4,128
Maybe another way to understand the concept of 'the instance', if you are not familiar with it, is to see an Instance of Sql Server as one installation. In other words, each time you install sql server you create an instance of it. Of course, this means that you can install multiple instances of Sql Server on one machine.

Chim Kalunta
Post #735594
Posted Tuesday, June 16, 2009 8:38 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, August 11, 2009 6:16 AM
Points: 8, Visits: 38
I have read through the material online and thanks for the url.
Tried to install 2 versions (2000 & 2005) of sql server on same machine and i can see that there are 2 sqlserver agents services. Thanks.
Post #736152
Posted Tuesday, June 16, 2009 9:34 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Sunday, July 6, 2014 3:07 PM
Points: 2,242, Visits: 3,643
Glad i could help you




Pradeep Singh
Post #736179
Posted Wednesday, June 17, 2009 1:42 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 2:18 AM
Points: 559, Visits: 1,159
Instances can also be useful if you have one server but need to pretend it's more! We have our development instance and our test instance co-existing happily on one server and they behave as two different servers.
Post #736267
Posted Wednesday, June 17, 2009 3:27 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, August 11, 2009 6:16 AM
Points: 8, Visits: 38
Is that the same installing 2 difference version of sql servers on same machine?
Post #736310
Posted Wednesday, June 17, 2009 4:05 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Sunday, July 6, 2014 3:07 PM
Points: 2,242, Visits: 3,643
Wintop (6/17/2009)
Is that the same installing 2 difference version of sql servers on same machine?

Yes. You can install same version of SQL Server multiple times as well. There is limitation for it. I guess in 2005 Std Edition/WorkGroup edition max no. of instances is 16 and in enterprize edition its 50. Just visit BOL to cross verify the max no. of instances.





Pradeep Singh
Post #736331
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse