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 |
|
franco
Constraint Violating Yak Guru
255 Posts |
 Posted - 2003-09-22 : 09:27:23
|
| I know that you can move SQL Server database to new location with detach/attach stored procedure (MS KB 224071).My question is related only to system databases and I would like to know if you, experts people, can suggest to have master,model and msdb log files on a different array too.I have all user *.MDF files on disk E: (Array 1) and all user *.LDF log files on disk F: (Array 2).Is it safe and a good practice to also move to disk F: system log files?And what about tempdb?My configuration:IBM x400:4 CPU Intel Xeon 2.0 GHZFront size BUS 400 Mhz2048 KB L2 cache4 GB PC133 Dimm RAM.FastT 700:14 drives 2 of this as Hot Spare, 1 for each battery of disks on the IBM Total Storage FASt T700 Storage Server with Dual Active RAID Controller-2GB Cache - Battery Backed.For the operating system we use the 2 x 36.4 GB 15K U160 SCSI Hot Swap internal, managed with IBM ServeRaid 4Mx U160 SCSI.Any help is really appreciate!Kind regards.Franco |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2003-09-22 : 13:33:39
|
| I don't think it would buy you anything. TempDB should be seperated, but I don't think the other system DBs need to be.-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
 |
|
|
|
|
|
Location of SQL Server log file (system)