June 10, 2008 at 12:27 pm
Hi Everybody,
What naming convention should I use for my sql server(not database), please give a good meaningful example.I have an old sql server and now i have to rename it with a good naming convention.
Thanks Irfan
June 10, 2008 at 1:36 pm
To each their own ... but my favorite thus far: Server, Environment, Application, Number.
For example:
SDVDB1
Server - Development - Database - Number
SQAWEB1
Server - QA- Web - Number
SIPDB1
Server - Production - Database - Number
Same can go for others ... SDVBIZTALK1, SQASHAREPOINT1, SIPWEB1, etc. etc.
This way you can make generic servers which you can instance more specifically. With the advancement of virtualization and higher resource servers, you can in fact have a development server with 10+ instances and name them specific to the scope while not having a specific server name that wouldn't be appropriate for future projects and such. As you max out resources on one machine, you bring up another and increment the #. Again giving you a generic server name that can serve multiple purposes vs. being geared towards the name of the box.
June 10, 2008 at 2:02 pm
Thank you very much for your time , thats good examples.
June 10, 2008 at 6:22 pm
To continue the list, here are the options
S: for Server
V: for Virtual Server
3: for windows 2003; 4 for windows 2008
Environment: PRD/QA/DEV
LOB – Line of business or application: MIS, MKT (marketing)
Loc - location: US or CA, or NY
DR: if it is a DR server
For example,
S3 PRD DB MIS US01
S3 PRD DB MIS US01 DR
V3 QA DB MKT CA01
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply