Re: MS SQL Database cluster - BAM (286 Views)
Reply
Frequent Advisor
testbravo
Posts: 67
Registered: ‎06-18-2012
Message 1 of 7 (314 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

HP Expert
Dmitry Shevchenko
Posts: 4,882
Registered: ‎01-30-2008
Message 2 of 7 (297 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.

Frequent Advisor
testbravo
Posts: 67
Registered: ‎06-18-2012
Message 3 of 7 (295 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 ?
HP Expert
Dmitry Shevchenko
Posts: 4,882
Registered: ‎01-30-2008
Message 4 of 7 (294 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.

Frequent Advisor
testbravo
Posts: 67
Registered: ‎06-18-2012
Message 5 of 7 (292 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 ?
HP Expert
Dmitry Shevchenko
Posts: 4,882
Registered: ‎01-30-2008
Message 6 of 7 (289 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.

Frequent Advisor
testbravo
Posts: 67
Registered: ‎06-18-2012
Message 7 of 7 (286 Views)

Re: MS SQL Database cluster - BAM

:)
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.