April 1, 2005 at 8:22 am
Hi All,
I am new here in sqlteam. I am also just starting with DBA role. I have a question on Creating more than 1 instance of sql server on 1 Server Box. I just want to know what are the advantages or disadvantages of having more than 1 instance of sql server...Because currently we are maintaining different databases in a single instance (original installation/local) of SQL Server...Is it safe? Administration part, is it wise to do it intead of having 1 huge database for all application?
Thanks in advance...
cheers,
miggie_ra
mgarier
April 1, 2005 at 9:01 am
Hi,
One of the recommendations of when to install instances is when you need separate security for different applications or customers. Logins belong to the instance, not to individual databases. So if you need a separate set of logins, or different server defaults like collation then you will use several instances instead of one with many databases.
Named Instances have different connection naming convention. If you connect to the default instance as MyServer, you will connect to the instance as MyMachine\MyNamedInstance.. Some applications are having difficult time with instances. Not ALL features are available. Default port is different.
On the other hand new application programmers like instances, they use MSDE to be installed with the application as an instance and it will not interfere with other apps that install their own instances.
Yelena
Regards,Yelena Varsha
April 1, 2005 at 9:26 am
that gave me a clear idea of using instance.
thanks Yelena
mgarier
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply