hi all I might be askin simple questions to you all, but plz bare with as iam much juniour to all people out there wat is an instance in sql server if any link which says clearly about it ill be happy thanks in advance trne DBA shashank sharma failure is elder brother of sucess
First you can ask any questions here. We all went this stage. we all were juniors at times. SQL Server you can have two or more sql servers in one Pc. that is called an instance. Say you PC name is A, then you can have default instance as A. if you want to have another instance for testing purposes that SQL server can be ATEST. These instances need not to be in same version of SQL Server. one can SQL Server 2000 one can be sql server 5 and one can be 2005. Read BOL for more configurations details ----------------------------------------
This is a link which describes about instances http://www.informit.com/guides/content.asp?g=sqlserver&seqNum=29&rl=1 ----------------------------------------
Shashank Few replies to your question may sound harsh, but we don't mean to ... hurt. IMHO it is better for you as well to refer to the books online and search thru the similar posts in the forum as well, that way the time is saved and you will learn more. Satya SKJ Microsoft SQL Server MVP Contributing Editor & Forums Moderator http://www.SQL-Server-Performance.Com This posting is provided �AS IS� with no rights for the sake of knowledge sharing.
