Re: MS SQL Database cluster - BAM (186 Views)
Reply
Frequent Advisor
testbravo
Posts: 67
Registered: ‎06-18-2012
Message 1 of 7 (214 Views)
Accepted Solution

MS SQL Database cluster - BAM

Hi

 

we have bsm 9.20 and we want to setup HA for MS SQL in bsm

 

pl suggest how this can be done

 

how the cluster will be configured

 

is that seperate license required for ms sql cluster

 

pl help if any document

Please use plain text.
HP Expert
Dmitry Shevchenko
Posts: 4,760
Registered: ‎01-30-2008
Message 2 of 7 (197 Views)

Re: MS SQL Database cluster - BAM

Your questions have little to do with BSM and are purely MSSQL related, so you'd better ask them in some SQL Server forum.

Please use plain text.
Frequent Advisor
testbravo
Posts: 67
Registered: ‎06-18-2012
Message 3 of 7 (195 Views)

Re: MS SQL Database cluster - BAM

I exepct BSM database guide should explain this

AS it is nicely explained for Oracle RAC than why not for MS MSQL ?
Please use plain text.
HP Expert
Dmitry Shevchenko
Posts: 4,760
Registered: ‎01-30-2008
Message 4 of 7 (194 Views)

Re: MS SQL Database cluster - BAM

1. MSSQL clustering gets officially supported only in the recently released BSM 9.22.

2. BSM 9.22 Database guide clearly says about SQL Server clustering:

 

Failover clustering is supported with all BSM databases. To configure failover clustering

with BSM, in the Setup and Database Configuration Utility enter the cluster server name as

the host name. No extra configuration is required.

 

So as far as BSM is concerned, configuration of MSSQL clustering support is not that complex as configuration of Oracle RAC support.

Please use plain text.
Frequent Advisor
testbravo
Posts: 67
Registered: ‎06-18-2012
Message 5 of 7 (192 Views)

Re: MS SQL Database cluster - BAM

just query before 9.22 is that there was no officical support for ha and failover for ms sql database in bsm ?
Please use plain text.
HP Expert
Dmitry Shevchenko
Posts: 4,760
Registered: ‎01-30-2008
Message 6 of 7 (189 Views)

Re: MS SQL Database cluster - BAM

There was no official support, but there were customers using it anyway and it worked. Simply because for BSM it's transparent how exactly the underlying SQL Server architecture is implemented - single node or cluster.

Please use plain text.
Frequent Advisor
testbravo
Posts: 67
Registered: ‎06-18-2012
Message 7 of 7 (186 Views)

Re: MS SQL Database cluster - BAM

:)
Please use plain text.
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation