topic Re: Manual fail over in Storage Software

Manual fail over

TerryG_1 — Mon, 01 Mar 2010 20:16:50 GMT

how do you manually fail over a sql server virtual instance from its primary to a backup?

Re: Manual fail over

Emil Velez — Tue, 02 Mar 2010 00:12:07 GMT

in the applications tab

drag and drop the checkmark from one node to the other.

Re: Manual fail over

Emil Velez — Tue, 02 Mar 2010 00:13:57 GMT

If you are interested HP has a course where you install polyserve and you install SQL and create and manage SQL instances with polyserve

www.hp.com/go/education

see the hf835 course.

Re: Manual fail over

TerryG_1 — Wed, 03 Mar 2010 15:01:33 GMT

I tried doing that to an instance running version 3.6.1 recently and it didn't work. All it did was change the primary node to the new server, similar to what rehost does.

In fact, when I went to the 'Help' tab that is exactly what the documentation said it would do.

Re: Manual fail over

Rodolfo E Vargas — Thu, 04 Mar 2010 19:43:08 GMT

I agree with Terry. I get the same result.

Re: Manual fail over

TerryG_1 — Mon, 08 Mar 2010 16:12:05 GMT

Does anyone from HP support have an answer to this?

Re: Manual fail over

Tammy Lawson — Tue, 09 Mar 2010 17:42:45 GMT

I have noticed if you are not running on your Primary node and then drag the check mark to another node, all it does is change your primary/secondary. In order to get the failover you expect, it must be running on the primary node. Usually I just drag twice to get the failover to occur.

Not sure if this is your situation or not.

Re: Manual fail over

TerryG_1 — Tue, 09 Mar 2010 18:44:59 GMT

Thanks, Tammy. I'll give that a try.

Re: Manual fail over

TerryG_1 — Tue, 09 Mar 2010 21:57:41 GMT

Tammy, I tried doing what you indicated, but all it did was switch the order of the primary and backup nodes. The node remained active on the same server and did not fail over. Definitely something strange going on here, because I know that this has worked in the past. Thanks, anyway!

Re: Manual fail over

Robert J. Horkay — Fri, 12 Mar 2010 16:47:13 GMT

Right click where it is currently hosted and select "disable", this will cause it to fail over.

I report this as a bug some time back, but HP is not very responsive anymore when it comes to sql on polyscum.

Re: Manual fail over

TerryG_1 — Fri, 12 Mar 2010 21:27:48 GMT

Robert,

That works, thanks. I also confirmed the process with HP support. However, just to make things interesting. We have a Polyserve environment set up in our lab where I can 'drag and drop' and cause a fail over.

Re: Manual fail over

Emil Velez — Sat, 19 Jun 2010 00:56:04 GMT

mx vsql move ....

and it will show you the syntax