dbTalk Databases Forums  

Best practice for naming instance

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss Best practice for naming instance in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #11  
Old   
Linchi Shea
 
Posts: n/a

Default RE: Best practice for naming instance - 07-22-2008 , 10:06 PM






When it comes to naming conventions, I don't think there is any best practice
here.

Yes, you can name your virtual server and your instance name identically.
They are in different name spaces, and so there won't be any conflict. For
instance, if your virtual server name is NYCSQLABC02, you can name the
instance on that virtual server as NYCSQLABC02, and you access that instance
as NYCSQLABC02\NYCSQLABC02. The advantage is that you don't have to remember
which instance goes with which virtual server. The downside is that the
virtual name \ instance name combo can get rather lengthy. We used this
naming convention for a while until we were tired of the long name, and opted
to just use SQL1, SQL2, and so on for the instance name.

Linchi

"Pasquale" wrote:

Quote:
Is it possible to name similarly the virtual server and the SQL instance for
a SQL clustered instance)?
In other terms, is it a best practice to assigne the same name for the
virtual server and for the SQL instance in a cluster?
Could be any problems to use the same names?
Thanks

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.