Alan Lawhon
lawhonac at hiwaay.net
Sat Aug 20 00:24:27 CDT 2011
Stuart: Thanks for the link. I think I understand why you would have named instances on the same machine. You might have one named instance for the engineering department of a very large company and a second named instance for the accounting department - with each department having their own databases and applications - and their own copy of SQL Server dedicated solely to their instance with both instances running on the same computer. (That computer better have a lot of horsepower - especially if you have multiple named instances running concurrently with lots of users on each instance.) Alan C. Lawhon -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan Sent: Friday, August 19, 2011 10:54 PM To: Discussion concerning MS SQL Server Subject: Re: [dba-SQLServer] SQL Server Book Two instances of SQL Server, means that you have two separate installations od the database engine running concurrently on the same machine The first time you instal SQL Server on a machine, it is automatically installed as the "Default Instance". You can then do a complete instal of SQL Server again, this time as a "Named Instance" where you specify a different name and different port(s) for it to operate on. The concept was introduces with SQL Server 2000. See http://msdn.microsoft.com/en-us/library/aa174516%28v=sql.80%29.aspx -- Stuart On 19 Aug 2011 at 22:03, Alan Lawhon wrote: > > What has me confused now is another section of the book where I read > that you can have "two instances" of SQL Server running simultaneously > on the same machine. If I recalled correctly, that would seem to > imply that an "instance" is a copy! (Maybe what that sentence was > implying is that you can have SQL Server running two different > [application] databases off the same SQL Server database engine > simultaneously - so the two separate databases are the "instances" - > while the [installed] SQL Server database engine is the entity.) > > _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com