Discussions specific to tape backups
aaron@ARB
Expert
Posts: 121
Liked: 12 times
Joined: Feb 21, 2014 3:12 am
Full Name: Aaron @ ARB
Contact:

SQL Error when looking at Tapes

Post by aaron@ARB » 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

Dima P.
Product Manager
Posts: 9605
Liked: 755 times
Joined: Feb 04, 2013 2:07 pm
Full Name: Dmitry Popov
Location: Prague
Contact:

Re: SQL Error when looking at Tapes

Post by Dima P. » Dec 28, 2016 12:56 pm

Hi Aaron,

Checking your cases. Stay tuned.

aaron@ARB
Expert
Posts: 121
Liked: 12 times
Joined: Feb 21, 2014 3:12 am
Full Name: Aaron @ ARB
Contact:

Re: SQL Error when looking at Tapes

Post by aaron@ARB » Dec 28, 2016 9:17 pm

No worries thanks, happy to log a 3rd case but i thought i would just check first...

Dima P.
Product Manager
Posts: 9605
Liked: 755 times
Joined: Feb 04, 2013 2:07 pm
Full Name: Dmitry Popov
Location: Prague
Contact:

Re: SQL Error when looking at Tapes

Post by Dima P. » 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.

aaron@ARB
Expert
Posts: 121
Liked: 12 times
Joined: Feb 21, 2014 3:12 am
Full Name: Aaron @ ARB
Contact:

Re: SQL Error when looking at Tapes

Post by aaron@ARB » 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.

Dima P.
Product Manager
Posts: 9605
Liked: 755 times
Joined: Feb 04, 2013 2:07 pm
Full Name: Dmitry Popov
Location: Prague
Contact:

Re: SQL Error when looking at Tapes

Post by Dima P. » 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.

aaron@ARB
Expert
Posts: 121
Liked: 12 times
Joined: Feb 21, 2014 3:12 am
Full Name: Aaron @ ARB
Contact:

Re: SQL Error when looking at Tapes

Post by aaron@ARB » 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?

v.Eremin
Product Manager
Posts: 15967
Liked: 1284 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: SQL Error when looking at Tapes

Post by v.Eremin » 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.

aaron@ARB
Expert
Posts: 121
Liked: 12 times
Joined: Feb 21, 2014 3:12 am
Full Name: Aaron @ ARB
Contact:

Re: SQL Error when looking at Tapes

Post by aaron@ARB » Mar 06, 2017 9:39 pm

Happy for you to see it in my environment, i can reproduce it quite regularly.

v.Eremin
Product Manager
Posts: 15967
Liked: 1284 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: SQL Error when looking at Tapes

Post by v.Eremin » 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.

aaron@ARB
Expert
Posts: 121
Liked: 12 times
Joined: Feb 21, 2014 3:12 am
Full Name: Aaron @ ARB
Contact:

Re: SQL Error when looking at Tapes

Post by aaron@ARB » 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

v.Eremin
Product Manager
Posts: 15967
Liked: 1284 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: SQL Error when looking at Tapes

Post by v.Eremin » 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.

aaron@ARB
Expert
Posts: 121
Liked: 12 times
Joined: Feb 21, 2014 3:12 am
Full Name: Aaron @ ARB
Contact:

Re: SQL Error when looking at Tapes

Post by aaron@ARB » Mar 14, 2017 12:46 am

I have moved this to our production SQL database, i will report back.

v.Eremin
Product Manager
Posts: 15967
Liked: 1284 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: SQL Error when looking at Tapes

Post by v.Eremin » 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.

aaron@ARB
Expert
Posts: 121
Liked: 12 times
Joined: Feb 21, 2014 3:12 am
Full Name: Aaron @ ARB
Contact:

Re: SQL Error when looking at Tapes

Post by aaron@ARB » Apr 02, 2017 8:17 pm

The problem remains. It just happened twice now. I am going to re own the support case.

Post Reply

Who is online

Users browsing this forum: Majestic-12 [Bot] and 3 guests