SQL Server Instance

Instance is name of server. It is a logical SQL server. First time, if we execute SQL Server setup, the installation uses the windows registered name that we called as default instance.

Named instances, if we run SQL server setup again a new SQL Server will be created to work. Each and every time it creates multiple instances.
Only one default instance will be there on the server.
Whenever we install SQL Server it will create new binary files for each installation.
Shared components like Management Studio, Business Intelligence Studio and other features will install only once.

Powered by k2schools