SQL Server 2014 in-guest cluster

Hyper-V specific discussions

SQL Server 2014 in-guest cluster

Veeam Logoby JamesNT » Mon 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
JamesNT
Influencer
 
Posts: 14
Liked: 1 time
Joined: Mon Feb 15, 2016 2:28 pm
Full Name: James Summerlin

Re: SQL Server 2014 in-guest cluster

Veeam Logoby Vitaliy S. » Fri 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!
Vitaliy S.
Veeam Software
 
Posts: 19558
Liked: 1102 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: SQL Server 2014 in-guest cluster

Veeam Logoby JamesNT » Fri 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
JamesNT
Influencer
 
Posts: 14
Liked: 1 time
Joined: Mon Feb 15, 2016 2:28 pm
Full Name: James Summerlin

Re: SQL Server 2014 in-guest cluster

Veeam Logoby Vitaliy S. » Fri 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).
Vitaliy S.
Veeam Software
 
Posts: 19558
Liked: 1102 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov


Return to Microsoft Hyper-V



Who is online

Users browsing this forum: No registered users and 3 guests