Discussions specific to the Microsoft Hyper-V hypervisor
Post Reply
JamesNT
Enthusiast
Posts: 36
Liked: 2 times
Joined: Feb 15, 2016 2:28 pm
Full Name: James Summerlin
Contact:

SQL Server 2014 in-guest cluster

Post by JamesNT » Feb 15, 2016 2:38 pm

We have a SQL Server 2014 in-guest cluster on top of our 2012 R2 hyper-v cluster.

Does Veeam support in-guest SQL clusters for backup? As of now, it appears our only choice is to have Veeam backup the SQL databases and truncate the logs on both VM's in the in-guest cluster. The problem is since this is an active-passive cluster, the job will always issue a warning when attempting to get the passive cluster member to backup and truncate the log (the active member is successful).

Can Veeam not connect directly to the SQL cluster itself like it does a Hyper-V cluster?

Thank you all for your assistance.

JamesNT

Vitaliy S.
Product Manager
Posts: 23001
Liked: 1557 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: SQL Server 2014 in-guest cluster

Post by Vitaliy S. » Feb 19, 2016 4:18 pm

Hi James,

SQL offers a number of clustering options. Can you please give us a bit more information about your configuration? Is it an Always On SQL server?

Thanks!

JamesNT
Enthusiast
Posts: 36
Liked: 2 times
Joined: Feb 15, 2016 2:28 pm
Full Name: James Summerlin
Contact:

Re: SQL Server 2014 in-guest cluster

Post by JamesNT » Apr 01, 2016 1:51 am

Standard Active-Passive SQL Server cluster using SQL Server 2014 Standard.

OS is all Windows Server 2012 R2.

JamesNT

Vitaliy S.
Product Manager
Posts: 23001
Liked: 1557 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: SQL Server 2014 in-guest cluster

Post by Vitaliy S. » Apr 01, 2016 3:39 pm

There is an existing topic discussing how this SQL Server can be backed up, please take a look > Backing up Always On MSSQL with Veeam (it's pretty long one, but has summary posts on the recommended approach).

Post Reply

Who is online

Users browsing this forum: No registered users and 3 guests