Avatar of corecc
corecc asked on

Can I move SATA RAID 1 array from HP ML310 G5 onboard controller to HP Smart Array P400?

Hi there,
We currently have a HP Proliant ML310 G5 running 2x 250Gb SATA hard drives in RAID 1 from the on-board RAID controller. This currently runs the OS, SQL Server and holds the SQL databases/transaction logs. We are considering purchasing a HP Smart Array P400 Controller (405132-B21) and 2x HP 300GB SAS Hard Drive (516814-B21) to hold the SQL databases/transaction logs. Is it possible to migrate/physically move the current SATA array from the on-board RAID controller to the new controller without losing data, add the two new SAS drives (creating a new RAID 1 array) so that we can then move the SQL databases/transaction logs to the new array. If this is possible, how would we do that? Many thanks in advance. Regards, Shaun Herridge – IT Manager.
Server HardwareEmbedded HardwareDisaster Recovery

Avatar of undefined
Last Comment
andyalder

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Robin Human

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
SOLUTION
jakethecatuk

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER
corecc

Many thanks for all of your responses, very useful/interesting. Would it be possible to run one array from the onboard controller, with the OS/SQL Server and one from the P400 holding the databases? I am trying to avoid have to image disks/reinstall (risk and limited windows of opportunity) and hoping I would just have to move the databases?
jakethecatuk

that would work.  You will have to add drivesr and arracy configuration utilities for the P400 to the installation of Windows.

once the drives are online, you can then move the databases.

you will have to make sure the BIOS is configured correctly for boot order so it doesn't try the P400 controller.
andyalder

Unfortunately cabling the backplane wouldn't work, there's only one connector on the backplane which goes either to the motherboard or the Pxx, see page 60 of http://bizsupport2.austin.hp.com/bc/docs/support/SupportManual/c01272014/c01272014.pdf

note that although it says SAS hard drive cabling it means raid controller cabling since Pxx support both SAS and SATA.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER
corecc

Thanks again for further comments. I am now plannng to leave the existing SATA array running from the system board (OS & SQL Server/transaction logs), adding a new SAS array running from a new P400 controller (holding only SQL databases). With reference to Andy Alder's comment, why would I not be able to do this considering the existing SATA array is attached to a SATA connector on system board and the new SAS array will be attached to a SAS connector on the P400 controller - the P400 controller being attached to a PCI Express slot on system board?
jakethecatuk

Just had a quick look at the link that AndyAlder posted.

Look at page 60 of the PDF.  The cage that the hot swap drives plug into looks like it has one connector on it that allows you to either connect to the mobo, or a raid card - not both.

That is what Andy is alluding to when he says you can't have both.
andyalder

They're also different cables so to use the P400 controller you need to buy the right cable. I suppose there may be a split cable available on the market with two SATA cables for the motherboard connection and the other two to the P400, but I don't think anyone makes one even though they're standard connectors.

Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER
corecc

Just to update, HP Technical Support have told me that I would be able to leave the existing SATA array, from system board (setting bootable in BIOS) and be able to add the P400/new array to hold just SQL data. (Have had different advise on whether to move the databases or the transaction logs - not sure what would give best performance increase?) I am still not 100% sure how I would physically do this, as comments/guide indicates only one cable from hot-plug drive cradle? Therefore, I am thinking that the only way to do this must be to add the SAS drives to the P400 card 'outside' of the hot-plug drive cradle? Does this sound doable? Unfortunately, being a live server, I cannot/don't really want to open it up at the moment? Apologies if I am asking the same question again but just want to be sure I can do this before I get the purchase of the P400 & drives signed off as these are not cheap.
jakethecatuk

It may be possible to add a second hard drive cage below the current one which can attach to your new controller.

http://h20141.www2.hp.com/Hpparts/%28X%281%29S%28zpvxn4io3i34qq55utnedru0%29%29/Search_Results.aspx?mscssid=A97E2E80660740459101D3EC50A1A413&SearchIn=Product

Product is called 'Cage'

Suggest you phone HP again and ask them if it is a valid option.
andyalder

ML3xx drive cage is a SCSI option for older servers, but it should be possible to mount the current SATA drives in the removeble media bays where you would normally put a tape drive (although they'd stop being hotswap). You'd get a couple of spare hotplug caddies that way as well.
Your help has saved me hundreds of hours of internet surfing.
fblack61