General discussion


Move from mirrored drives to Array 5

By casta ·
Hi all:

I have a Compaq Proliant ML350 G2 that is configured like this:

(2) 18GB Ultra 320 SCSI drives configured in a hardware mirror array that contain OS files
(1) 36GB drive that it's not fault tolerant.

The server is a Windows 2000 server SP4 in a W2K AD domain with all critical updates installed and it's running SQL 2000 and some finance applications (Great Plains) the 36GB standalone drive is being used to store all SQL backups.

I have (3) 36GB Ultra 320 drives available and I was wondering if moving this installation to a RAID 5 would increase performance and reliability on the server in regards to SQL and in general.

Which is the best way to move the current installation onto a RAID 5?

I have full backups everyday using Veritas Backup Exec. However, I do not have the SQL agent to backup the SQL files which is my main concern.

Do I need to buy the SQL agent in order for me to move that database safely into the RAID 5? I just don?t want to break what?s not broken!

Server is up and running without any problems, but I am just looking for ways to make it faster and more reliable. Since I have 3 drives available might as well, this does not happen all the time! ;-)

Thanks in advance.

John C

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by ewgny In reply to Move from mirrored drives ...

Many major brand Backup software packages have image options. Veritas has an image option.
A backup to an image file can be an advantage, since it avoids the typical file restore, which could require that you install the operating system and backup software to be able to restore.
Also a key factor is if your current raid is software based (through windows) or hardware based (through your SCSI controller) You would want the latter for performance in your new RAID 5 Setup. Hardware based raid is usually needed to use the imaging features of the backup software, since striping is defined by the controller not windows. So you should be able to image your server install your raid 5 Array, and restore. Check with Veritas, but I think that the image option would be a better choice than the SQL agent. It also would enhance your disaster recovery plan for the future. You could then for example make server images one day a week with file backups the other days. In the event of a disaster, you could quickly restore the server with the image, and then bring it up to date with a file by file restore

Collapse -

by ewgny In reply to

You should be able to just stop the SQL service prior to backup, so that the sql files won't be skipped due to being in use.
The only reason I mentioned the image option, was that you seemed to be open to purchasing the SQL agent, and the image option is probably a better option for the reasons that I stated.
You should try backing up and restoring to a test server that you install SQL on prior to the actual
server upgrade.
Hint - Some backup companies have fully functional trial software (including image option)
Try it on a test server.
Good Luck

Collapse -

by casta In reply to

Poster rated this answer.
Thanks a lot for all your help in this matter.

Collapse -

by casta In reply to Move from mirrored drives ...

Thanks for the info.However, I was wondering if I could perform this data migration using what I have instead of buying additional software.

Collapse -

by casta In reply to Move from mirrored drives ...

This question was closed by the author

Related Discussions

Related Forums