2005: System DB's on different volume then program files 1

[johnny99]

Hi

In SQL 2000 I could install SQL server in Program Files on C: and have my system DB's on eg F:

But can anyone tell me how I do the same on SQL 2005?

/johnny

 

[ptheriault]

when you get to the Components to Install screen select the advanced button. This will allow you to change the directory for the install.

- Paul
- Database performance looks fine, it must be the Network!

 

[johnny99]

Hi Paul

I think I tried that, but if I understand it right I can only change where I will install the SQL server so I will end up with both the SQL server and the system databases on that location.

Or have I missunderstood that?

/johnny

 

[ptheriault]

That is correct
You can move your master database by changing the -d and -l startup paremetes in the SQL Server config manager.
You can then move your other system databases with a restore or detach method.

You can move the tempdb with this script.
use master
go
Alter database tempdb modify file (name = tempdev, filename = 'D:\programs\mssql\data\tempdb.mdf')
go
Alter database tempdb modify file (name = templog, filename = 'D:\programs\mssql\data\templog.ldf')
Go

- Paul
- Database performance looks fine, it must be the Network!