Re: HP DP 8 and Microsoft SQL Server 2012 Alwayson integration question (740 Views)
Reply
Occasional Advisor
slicer
Posts: 13
Registered: ‎08-26-2010
Message 1 of 2 (770 Views)
Accepted Solution

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.

Honored Contributor
danielbraun
Posts: 731
Registered: ‎07-07-2010
Message 2 of 2 (740 Views)

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