Data Protector Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

HP DP 8 and Microsoft SQL Server 2012 Alwayson integration question

SOLVED
Go to solution
slicer
Occasional Contributor

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
Highlighted
danielbraun
Honored Contributor
Solution

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...
//Add this to "OnDomLoad" event