Data Protector Practitioners Forum
Showing results for 
Search instead for 
Do you mean 

HP DP 8 and Microsoft SQL Server 2012 Alwayson integration question

SOLVED
Go to Solution
Highlighted
Occasional Advisor

HP DP 8 and Microsoft SQL Server 2012 Alwayson integration question

Hi,

 

  Our environment:

 

- DP 8 Cell Manager, Windows

- 2 X Windows 2012 server clients with MS SQL Server 2012 Alwayson enabled.

 

We have a 2 node SQL Server 2012 cluster. Anyone know how we can configure the DP integration to point the backup to the passive node only?

 

Please advise.

1 REPLY
Honored Contributor

Re: HP DP 8 and Microsoft SQL Server 2012 Alwayson integration question

HI,

 

you need to import the listener first into Data Protector and create a backup specification as it works for SQL 2008. In the application specific options there was added a tab "MSSQL Backup preference" where you can select "Secondary only".

 

Best regards

Daniel

-----------
Please assign Kudos - How to assign...