SQL Error when looking at Tapes

Everything about backing up to tape

SQL Error when looking at Tapes

Veeam Logoby aaron@ARB » Wed Dec 28, 2016 12:33 am

Veeam,

I have had 2 jobs logged now for an SQL error when looking at tapes (Jobs 01806664 and 01879550). The error is still present in 9.5. Should I log another job? Is it going to be fixed in a version coming up? Its just that its incredibly annoying!

Image

Cheers,
Aaron
aaron@ARB
Expert
 
Posts: 112
Liked: 12 times
Joined: Fri Feb 21, 2014 3:12 am
Full Name: Aaron @ ARB

Re: SQL Error when looking at Tapes

Veeam Logoby Dima P. » Wed Dec 28, 2016 12:56 pm

Hi Aaron,

Checking your cases. Stay tuned.
Dima P.
Veeam Software
 
Posts: 6263
Liked: 442 times
Joined: Mon Feb 04, 2013 2:07 pm
Location: SPb
Full Name: Dmitry Popov

Re: SQL Error when looking at Tapes

Veeam Logoby aaron@ARB » Wed Dec 28, 2016 9:17 pm

No worries thanks, happy to log a 3rd case but i thought i would just check first...
aaron@ARB
Expert
 
Posts: 112
Liked: 12 times
Joined: Fri Feb 21, 2014 3:12 am
Full Name: Aaron @ ARB

Re: SQL Error when looking at Tapes

Veeam Logoby Dima P. » Thu Dec 29, 2016 11:32 am

Aaron,

It's not required. I checked with DEVs and they are working on a fix. I was told that this could be fixed by updating the SQL database with this patch. If you are going to do it, do not forget to take a VBR’s configuration backup before installing the patch, just in case.
Dima P.
Veeam Software
 
Posts: 6263
Liked: 442 times
Joined: Mon Feb 04, 2013 2:07 pm
Location: SPb
Full Name: Dmitry Popov

Re: SQL Error when looking at Tapes

Veeam Logoby aaron@ARB » Mon Jan 02, 2017 9:37 pm

I am already running SP3 which given that the link doesn't include it, I assume means that it was already fixed by SP3?

Nonetheless, I am downloading the latest CU (6) (https://www.microsoft.com/en-us/downloa ... x?id=50733) and will see if that helps.
aaron@ARB
Expert
 
Posts: 112
Liked: 12 times
Joined: Fri Feb 21, 2014 3:12 am
Full Name: Aaron @ ARB

Re: SQL Error when looking at Tapes

Veeam Logoby Dima P. » Mon Jan 02, 2017 10:39 pm

Aaron,

This CU should be installed on top of the SP3. Let us know how it goes, meanwhile I’ll push the team to include a fix from our side to the upcoming update.
Dima P.
Veeam Software
 
Posts: 6263
Liked: 442 times
Joined: Mon Feb 04, 2013 2:07 pm
Location: SPb
Full Name: Dmitry Popov

Re: SQL Error when looking at Tapes

Veeam Logoby aaron@ARB » Mon Mar 06, 2017 5:39 am

Any news on when this will be fixed? I have just installed VBR 9.5 SP1 and the fault is still there even with the latest SQL updates etc. We have had a few VBR updates since I first reported the issue to support (and been told 'yeah a fix is coming'), can we have some traction on it please?
aaron@ARB
Expert
 
Posts: 112
Liked: 12 times
Joined: Fri Feb 21, 2014 3:12 am
Full Name: Aaron @ ARB

Re: SQL Error when looking at Tapes

Veeam Logoby v.Eremin » Mon Mar 06, 2017 12:59 pm

It turned our that the issues is hard to reproduce and requires a more complex fix that we've originally thought. So, according to the plan, it should be fixed in version 10, rather than in one of the upcoming updates. Thanks.
v.Eremin
Veeam Software
 
Posts: 13296
Liked: 974 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin

Re: SQL Error when looking at Tapes

Veeam Logoby aaron@ARB » Mon Mar 06, 2017 9:39 pm

Happy for you to see it in my environment, i can reproduce it quite regularly.
aaron@ARB
Expert
 
Posts: 112
Liked: 12 times
Joined: Fri Feb 21, 2014 3:12 am
Full Name: Aaron @ ARB

Re: SQL Error when looking at Tapes

Veeam Logoby v.Eremin » Tue Mar 07, 2017 11:14 am

I'm wondering what type of SQL server you're using. Built-in SQL Express or fully blown SQL server.
v.Eremin
Veeam Software
 
Posts: 13296
Liked: 974 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin

Re: SQL Error when looking at Tapes

Veeam Logoby aaron@ARB » Tue Mar 07, 2017 9:56 pm

v.Eremin wrote:I'm wondering what type of SQL server you're using. Built-in SQL Express or fully blown SQL server.


Builtin
aaron@ARB
Expert
 
Posts: 112
Liked: 12 times
Joined: Fri Feb 21, 2014 3:12 am
Full Name: Aaron @ ARB

Re: SQL Error when looking at Tapes

Veeam Logoby v.Eremin » Thu Mar 09, 2017 9:32 am

Don't you happen to have a full blown SQL server at hand? If so, it might stand to reason to switch workloads to it to avoid the said issues. Thanks.
v.Eremin
Veeam Software
 
Posts: 13296
Liked: 974 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin

Re: SQL Error when looking at Tapes

Veeam Logoby aaron@ARB » Tue Mar 14, 2017 12:46 am

I have moved this to our production SQL database, i will report back.
aaron@ARB
Expert
 
Posts: 112
Liked: 12 times
Joined: Fri Feb 21, 2014 3:12 am
Full Name: Aaron @ ARB

Re: SQL Error when looking at Tapes

Veeam Logoby v.Eremin » Tue Mar 14, 2017 10:01 am

Having a product db running on full SQL server should fix the given problem, indeed. Kindly, let us know, if the issue persists.
v.Eremin
Veeam Software
 
Posts: 13296
Liked: 974 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin

Re: SQL Error when looking at Tapes

Veeam Logoby aaron@ARB » Sun Apr 02, 2017 8:17 pm

The problem remains. It just happened twice now. I am going to re own the support case.
aaron@ARB
Expert
 
Posts: 112
Liked: 12 times
Joined: Fri Feb 21, 2014 3:12 am
Full Name: Aaron @ ARB

Next

Return to Tape



Who is online

Users browsing this forum: No registered users and 7 guests