Truncate log, manage SQL log shipping with shared vhdx

Hyper-V specific discussions

Truncate log, manage SQL log shipping with shared vhdx

Veeam Logoby Someonenew2014 » Thu May 07, 2015 9:56 pm

Hi ...

We are running SQL cluster 2012, WIndows 2012. All over Hyper-V 2012 R2.

We are using Shared vhdx for two node installation, backing up sql in crash consistent state. We are fine with that.

We are planning to use SQL shipping for DR as shared vhdx not support for replication.


1- In our case can we configure transaction log backup though VAEEM?

2- If answer is Yes, as you know log shipping is shipped the log and truncate the transnational log. Can I use copy-only backup through VAEEM.

3- If both answers are yes, can we restore though VAEEM like point-in-time recovery ( like AAP with single vhdx). using SQL explorer so I can choose the time when restore?


VAEEM v.8 we are using.


Thank you.
Someonenew2014
Enthusiast
 
Posts: 54
Liked: 3 times
Joined: Wed Feb 04, 2015 8:25 pm

Re: Truncate log, manage SQL log shipping with shared vhdx

Veeam Logoby foggy » Fri May 08, 2015 2:14 pm

Logs backup is not possible in case of shared VHDX, since there is no application-aware guest processing (crash-consistent backup).
foggy
Veeam Software
 
Posts: 14765
Liked: 1083 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: Truncate log, manage SQL log shipping with shared vhdx

Veeam Logoby Someonenew2014 » Fri May 08, 2015 4:43 pm

Thank you.

So in this case VAEEM backup is enough and no need for SQL backup.
Someonenew2014
Enthusiast
 
Posts: 54
Liked: 3 times
Joined: Wed Feb 04, 2015 8:25 pm

Re: Truncate log, manage SQL log shipping with shared vhdx

Veeam Logoby foggy » Fri May 08, 2015 4:45 pm

I didn't say it is enough, I just said that it is the only thing that is possible with Veeam B&R. ;)
foggy
Veeam Software
 
Posts: 14765
Liked: 1083 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: Truncate log, manage SQL log shipping with shared vhdx

Veeam Logoby Someonenew2014 » Fri May 08, 2015 7:38 pm

Thanks. I mean is it reliable ? and can be trusted, I did my own test and it is worknig fine.

of course VAEEM did multiple test :)
Someonenew2014
Enthusiast
 
Posts: 54
Liked: 3 times
Joined: Wed Feb 04, 2015 8:25 pm

Re: Truncate log, manage SQL log shipping with shared vhdx

Veeam Logoby foggy » Fri May 08, 2015 8:52 pm

Typically, SQL Server is able to successfully recover from crash-consistent backup. You just will need to use native tools to do point in time restores.
foggy
Veeam Software
 
Posts: 14765
Liked: 1083 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: Truncate log, manage SQL log shipping with shared vhdx

Veeam Logoby Someonenew2014 » Sat May 09, 2015 11:14 am

Thank you.
Someonenew2014
Enthusiast
 
Posts: 54
Liked: 3 times
Joined: Wed Feb 04, 2015 8:25 pm

Re: Truncate log, manage SQL log shipping with shared vhdx

Veeam Logoby Someonenew2014 » Wed May 13, 2015 7:36 am

So in this case, do VAEEM have a workaround for backup TL inside shared vhdx
Someonenew2014
Enthusiast
 
Posts: 54
Liked: 3 times
Joined: Wed Feb 04, 2015 8:25 pm

Re: Truncate log, manage SQL log shipping with shared vhdx

Veeam Logoby foggy » Wed May 13, 2015 11:12 am

As mentioned, you can use native tools for that purpose.
foggy
Veeam Software
 
Posts: 14765
Liked: 1083 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: Truncate log, manage SQL log shipping with shared vhdx

Veeam Logoby Someonenew2014 » Sat Jul 18, 2015 1:24 am

Thank you.
Someonenew2014
Enthusiast
 
Posts: 54
Liked: 3 times
Joined: Wed Feb 04, 2015 8:25 pm


Return to Microsoft Hyper-V



Who is online

Users browsing this forum: No registered users and 5 guests