2005 Installation questions 1

[thamms]

Hi,

I just did an installation, and I want to get a reality check.

Q1.) I downloaded SQL Server 2005 (x86) from the developer website as ISO files. There were 2 files: CD 1 and CD 2.
I mounted the ISO files so I could read the contents. I ran setup.exe from CD 1.

The installation only required setup.exe from CD 1. CD 2 was tools only, so I didn't need to install anyting from CD 2.

This differs from my experience of installing from DISKS, where you DO need both CD's. Can anyone confirm why the ISO files only required CD 1?

Q2.) Also, under the "Advanced" menu I wasn't sure where to change the default installation for the System databases. Can someone please clarify. As it was, I chose to install everything under c:\program files\sql server\mssql.1\mssql\data\... but in the past I have changed this, but I don't remember HOW I did this.

Thanks

 

[mrdenny]

1. You should only need disk 1.

2. In the advanced menu (clicking advanced on the page with the list of services) click the plus next to SQL Server and select databases to change the path the databases will be stored in.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[thamms]

Thanks. Is there a way to specify a separate location for the system db data and log files? That is, putting the log files in their own location?

 

[mrdenny]

Nope, not with SQL 2005. SQL 2008 lets you do this during the install. There's not much point in moving the system databases log files. Traffic to the system databases (except tempdb) is usually fairly low.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[MasterRacker]

Great timing in this thread as I just built a SQL 2005 server also. I have an E: drive for logs and an F: drive for data and have moved the user DBs appropriately. I've seen some documentation that suggests rebuilding the master DB requires re-moving other system DBs as they get restored to default locations so I was also thinking of not bothering.

So out of master, model, msdb and tempdb, you're saying I don't need to bother with anything but tempdb?

_____
Jeff
[small][purple]It's never too early to begin preparing for [/purple]International Talk Like a Pirate Day
"The software I buy sucks, The software I write sucks. It's time to give up and have a beer..." - Me[/small]

 

[thamms]

I wanted to add something to my original post.

If you are installing the 64 bit version of SQL Server 2005 standard edition from downloaded files, you definitely need both CD's, not just CD1. I ran into myriad problems under the previous assumption of only needing one disk, even though CD2 only contains tools... the installer chokes without the files from CD2!

 

[mrdenny]

This is why I always use the DVD. Only one disk that way.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog