building sql server 2000 Documentation | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

building sql server 2000 Documentation

i need to document processes of instalation new sql server
does any one have it to share?
thank you
See BOL and online documentation athttp://msdn.microsoft.com/library/en-us/instsql/in_overview_0v3l.asp?frame=true Gaurav
Moderator
Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard
yes i know about this one.I hoped to get doc with all optimizations …
Check out Technet: IT Tasks,SQL Server, Planning Nathan H.O.
Moderator
SQL-Server-Performance.com
If i rephrase my question.<br />after sql instalation what setting should i optimise?<br />After few previouse question i understood to keep everything as a default<img src=’/community/emoticons/emotion-4.gif’ alt=’:p‘ />rotocol<br />queue,etc…<br />Or there is some settings that better be change right after installation?
If you are installing SQL 7.0 there is a lot of settings to change, depending on harware.
If SQL 2000, defaults works very well Luis Martin …Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
Bertrand Russell
yes this is sql 2000
Sorry I don’t see post title. Luis Martin …Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
Bertrand Russell
If you can send me your email to me, I can send the document placed at my end on all my services. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com
Could you tell me what is the better way:
use default name for sql instance or use named instance?
and also what kind of feature is recommended to use typical or custom(do i need developmemt tools)
Hope you got my email with the links provided for the information you’re looking. Coming to the instance, if you choose to install default instance then leave the value as it is to pickup the machine name. If not choose your own name for named instances. Keep in mind only you can have one default instance and many named instances depending upon the server configuration & capacity. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com
thank you for your email. But i still have a lot of questions about installation.
for example shouls i tick autostart service for sql server only not for agent?
and features still remains the question.
also can i during installation specify that log files must be kept on different drive?
No worries keep your questions coming….. Always choose to AUTOSTART – MSSQLServer & MSSQLAgent services and if you ues distributed transactions then make sure MSDTC is also set for the same. Coming to the log files part, this can be specified only when you create the database. Now its only part of SQL Server installation which is required to create the database. HTH _________
Satya SKJ
Moderator
SQL-Server-Performance.Com
thank you. Now Network Libraries .
I notice all our servers in Server Utilities have Only TCP/Ip protocol.
and in Client utilities TCP/ip goes first and then Named pipes.
I never read anything about this but i remember i heard from someone that this is a good practise . something about security… During installation shoud i uncheck named pipes?
If on the network clients all are using TCP/IP then better leave the settings to use TCP/IP and I don’t think you can disable Named pipes during installation. If not required can disable in post installation. Refer thru this link for security best practiceshttp://www.microsoft.com/technet/prodtechnol/sql/maintain/security/sp3sec/SP3SEC04.ASP and also under Forum Anouncements where you can find handful informational links posted by Gaurav and me. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com
Also this linkhttp://www.sqlsecurity.com for all kind of fundas about security…. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com
]]>