Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jbates99
Constraint Violating Yak Guru
396 Posts |
 Posted - 2010-10-27 : 22:21:18
|
| Hi everyone,I'm doing my first installation of SQL 2008. This is Standard 64-bit edition on Windows 2003.I want the system databases to reside on the E drive, not the operating system drive (C:) which is probably the default.1. Will I be able to choose the drive during the installation ? I want to avoid having to move the system databases after the install, that can get ugly.2. Another question - This is 2008 R2. Does it already include Service Pack 1? Which SP is the latest (solid) for 2008?Thanks much!John |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-10-28 : 00:25:07
|
| yes you can specify. it will ask during installation where u want 'emno, apply SP1 immediately after install of sql 2008. it will complain about processes in use (sqlserver.exe for one). you can ignore this and reboot after applying sp1 |
 |
|
|
psychotic_savage
Starting Member
25 Posts |
Posted - 2010-10-28 : 05:51:49
|
| During the installation look under the:Database Engine Configuration / Data Directories TabHere you can also set the User DB locations, backup location and Log locations :) |
|
|
|
jbates99
Constraint Violating Yak Guru
396 Posts |
Posted - 2010-10-28 : 09:50:33
|
| Thanks for the good information and advice, russell and psychotic savage! |
|
|
|
|
|
|
Installing 2008 Standard onto a Non-OS Drive