Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 What's instance in SQL Server?

Author  Topic 

wkm1925
Posting Yak Master

207 Posts

Posted - 2010-10-18 : 10:56:37
What's instance in SQL Server?

I need easy explanation

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-10-18 : 12:51:55
Starting with SQL Server 2000, you can have multiple instances of SQL Server installed on one computer/server. An instance is just one particular installation. It has its own set of binaries, data files, ..., practically everything except common files.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

wkm1925
Posting Yak Master

207 Posts

Posted - 2010-10-19 : 00:06:35
tq sir
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-10-19 : 00:37:09
Sir? Okay. I hate when people make assumptions. It may be a male dominated field, but there are females in the field too.

You're welcome, glad to help.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -