Sql Server Instances

• ekonagu

  SSChasing Mays

  Points: 657

  More actions

  July 7, 2009 at 3:09 am

  #132490

  Hai guys

  Pls tel me what is an instance, multiple instances

  what is the use of multiple instances

  pls help

• NicHopper

  SSCrazy Eights

  Points: 9090

  More actions

  July 7, 2009 at 3:12 am

  #1020931

  Hi,

  An instance, refers to an instance (installation) of SQL Server.

  If you had 2 instances of SQL Server installed on a server then you could for example run a development and test database environment from 1 machine.

  Hope this makes sense.

  Check out my blog http://www.sqlservercentral.com/articles/Best+Practices/61537/

• ekonagu

  SSChasing Mays

  Points: 657

  More actions

  July 7, 2009 at 3:33 am

  #1020934

  Thanks A lot