Discussion: Disk set up
Afficher un message
Vieux 30/10/2006, 09h32   #4
Hank Arnold
Aucun Avatar
 
Messages: n/a
Hébergeur:
Par défaut Re: Disk set up

Your post is a bit confusing. You fist say that you have RAID 1 and then
later say you don't want to corrupt the data on RAID 0.

Best configuration is:

1) RAID 1 - Boot & SQL (2 drives)
2) RAID 1 - Log files (2 drives)
3) RAID 10 - Databases (4 drives)

If absolutely necessary, you could go with

1) RAID 1 - Boot & SQL & log files (2 drives)
2) RAID 10 - Databases (4 drives)

All RAID arrays should be on their own channel. Otherwise you can get
contention (read performance)problems with one channel...

If you actually have RAID 1 already, then add the other arrays and move
the log and/or databases. If you actually have RAID 0, then converting
it to RAID 1 will lose all your data....


Regards,
Hank Arnold

jimbo345 wrote:
> I have recently taken over at a company that is running SQL 2005 on a server
> that has two disk in a Raid 1 configuration. I am not that up to date on SQL
> and would like to know if it is possible to add more disks to change it to a
> raid 0 + 1 set up without corrupting the data that is currently on the Raid 0.
>
> thanks in advance.

  Réponse avec citation
 
Page generated in 0,06346 seconds with 9 queries