| Author |
Topic |
|
tsaico
Starting Member
1 Post |
 Posted - 2008-07-11 : 18:36:22
|
| I have 8 drive total, C is a RAID 1 for just OS and Program files. D is RAID 5 for database, and E is RAID 5 for transaction logs. I finished installing SQL 2005, no errors produced, but I do not know how to confirgure where to tell SQL 2005 to do this. I see the management studio, and also the preferences for the default datbases in SQL, but no where to see where the actual database is being stored, where the transaction logs are stored, or how to change it. Anyone can point me in the right direction or even tell me where to find it? Totally new to SQL so you may have to be more descriptive. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-11 : 18:43:55
|
| While installing you should have chosen Advanced option to specify your data files and Log files. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-12 : 00:21:50
|
| You can change db file default location in server properties -> database settings in ssms. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-12 : 11:39:09
|
quote:
Originally posted by rmiao
You can change db file default location in server properties -> database settings in ssms.
That applies only to newly created database.Doesn't apply to Existing databases. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-12 : 13:47:36
|
| That's true. The point is you don't have to alter db file location for new dbs anymore once set correct default locations. |
|
|
|
laddu
Constraint Violating Yak Guru
332 Posts |
Posted - 2008-07-12 : 14:01:34
|
quote:
Originally posted by rmiao
That's true. The point is you don't have to alter db file location for new dbs anymore once set correct default locations.
Data and log files should be on separate physical drives so that in case of a disaster, you have a better chance of recovering all data.Transaction logs are best placed on a RAID-1 array because this has the fastest sequential write speedData files are best placed on a RAID-5 array because they have faster read speed than other RAID arraysIf you have access to a RAID 10 array, you can place data and log files on it because it has all the advantages of RAID 1 and RAID 5 |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-12 : 14:21:04
|
quote:
Originally posted by rmiao
That's true. The point is you don't have to alter db file location for new dbs anymore once set correct default locations.
Only if you have single data file. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-12 : 17:19:26
|
| Not really, you have to add them separately anyway if need multiple data files. |
|
|
|
|
How to setup database and transaction log location