Install SQL Server 2008

Microsoft has made the SQL Server 2008 install more function rich then the previous version. They have included functionality into this install which make it easier to set up setups and configure the SQL Server settings that in previous version you would have to do post install.

For example setting up sysadmin privileged accounts:

We saw a similar screen to in the later service pack releases of SQL Server 2005. To me this is one of the most important functions; because installing SQL Server 2005 on servers in gave local administrators SA rights on the server. So anyone part of domain administrators and server operations essentially got SA on the SQL Server which made it difficult to manage the servers because you’ll have databases created on the server out of the blue or jobs that you didn’t know that existed. I can go on rant about that but I’ll stop here…

Next long over due addition in the setup is directory structure:

In 2005 setup we were able to change the data directory; which made it so the system databases’ (master, model, msdb, tempdb) data and log files, along with all user databases were stored in the entered location. In addition we had to manually set the log file path for all user databases if we wanted it to be in different location. We also had to use “alter database” statements for tempdb to locate it on a different drive. Another nice added bonus is Backup Directory!! I had made a post on how to change default backup directory path for 2005 earlier last month as the GUI and the Setup didn’t give you that option (link). All these are nice a plus, I would have liked to have the ability to set the number of data files for the tempdb. As per Microsoft’s recommendation most people are splitting up tempdb to number of CPU in their server; since this functionality is not available in setup this will still need to be completed manually.

Here is a complete setup document on step-by-step guide, link.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.