SQL unavailable

Backup agent for Microsoft Windows servers and workstations (formerly Veeam Endpoint Backup FREE)

SQL unavailable

Veeam Logoby darkhelmet » Mon Jan 19, 2015 10:17 am

I have installed Veeam on W8.1 64-bit with VEB beta.

I get an error when trying to make a backup (the first):

19-1-2015 11:12:09 :: Microsoft SQL server hosting the configuration database is currently unavailable. Possible reasons are heavy load, networking issue, server reboot, or hot backup. Please wait, and try again later. Error information: Cannot insert duplicate key row in object 'dbo.BObjects' with unique index 'IX_BObjects'. The duplicate key value is (6745a759-2205-4cd2-b172-8ec8f7e60ef8, 4c4c4544-005a-3210-8058-b3c04f463132). The statement has been terminated.

SQL services are running, restarting the laptop has no effect. Pausing anti-virus (Avira) has no possitive effect either.
Laptop is nearly idle, backup destination is a USB drive.

I can try to reinstall Veeam, but i'd like to know what's broken....
darkhelmet
Service Provider
 
Posts: 13
Liked: 1 time
Joined: Wed Aug 04, 2010 1:41 pm

Re: SQL unavailable

Veeam Logoby Mike Resseler » Mon Jan 19, 2015 10:20 am

Hi,

This looks like an interesting issue. the fact that it states that he cannot insert a duplicate key doesn't seem nomal. Could you go to the control panel of Veeam Endpoint Backup, support tab and use the technical support to submit a support case? It might be known already, but I haven't seen the issue yet.

Thanks for your help!

Mike
Mike Resseler
Veeam Software
 
Posts: 3151
Liked: 362 times
Joined: Fri Feb 08, 2013 3:08 pm
Location: Belgium, the land of the fries, the beer, the chocolate and the diamonds...
Full Name: Mike Resseler

Re: SQL unavailable

Veeam Logoby darkhelmet » Mon Jan 19, 2015 10:21 am

Mike Resseler wrote:Hi,

This looks like an interesting issue. the fact that it states that he cannot insert a duplicate key doesn't seem nomal. Could you go to the control panel of Veeam Endpoint Backup, support tab and use the technical support to submit a support case? It might be known already, but I haven't seen the issue yet.

Thanks for your help!

Mike


it was just submitted: 00730101 :D
darkhelmet
Service Provider
 
Posts: 13
Liked: 1 time
Joined: Wed Aug 04, 2010 1:41 pm

Re: SQL unavailable

Veeam Logoby Mike Resseler » Mon Jan 19, 2015 10:30 am

Thanks a lot!

Cheers

Mike
Mike Resseler
Veeam Software
 
Posts: 3151
Liked: 362 times
Joined: Fri Feb 08, 2013 3:08 pm
Location: Belgium, the land of the fries, the beer, the chocolate and the diamonds...
Full Name: Mike Resseler

Re: SQL unavailable

Veeam Logoby darkhelmet » Mon Jan 19, 2015 2:27 pm 1 person likes this post

And i already got a response from support. The described solution worked, although i cant continue on the previous backup.

1. stop EndPoint service
2. execute regedit. go to HKEY_LOCAL_MACHINE\SOFTWARE\Veeam\Veeam Endpoint Backup\ and make a new DWORD value recreatedatabase=1
3.restart service
4.delete previously created value
5. at this point we can`t do any FLR yet, you will need to configure a new backup job, save the previous backup folder to a different destination or rename the current folder, because the old backup chain will not be picked up 6. start the backup job, once it`s complete FLR can be run
darkhelmet
Service Provider
 
Posts: 13
Liked: 1 time
Joined: Wed Aug 04, 2010 1:41 pm

Re: SQL unavailable

Veeam Logoby darkhelmet » Mon Jan 19, 2015 2:30 pm

backup running flawless now. Takes 10:35 for a full

For comparison Symantec System Recovery 2013 R2 takes only 8:15 for exactly the same backup, so even faster. But still Veeam feels fast
darkhelmet
Service Provider
 
Posts: 13
Liked: 1 time
Joined: Wed Aug 04, 2010 1:41 pm

Re: SQL unavailable

Veeam Logoby Dima P. » Mon Jan 19, 2015 8:49 pm

darkhelmet,
Glad, you are up and running now.
For comparison Symantec System Recovery 2013 R2 takes only 8:15 for exactly the same backup, so even faster. But still Veeam feels fast

Just to be on the same page these are performance results for full backup run (or it was incremental)?
Dima P.
Veeam Software
 
Posts: 6242
Liked: 440 times
Joined: Mon Feb 04, 2013 2:07 pm
Location: SPb
Full Name: Dmitry Popov

Re: SQL unavailable

Veeam Logoby JoshHawley » Tue Jun 02, 2015 7:47 pm

Thanks for posting this! I had the same problem, and this worked for me too.
JoshHawley
Lurker
 
Posts: 1
Liked: never
Joined: Tue Jun 02, 2015 7:38 pm
Full Name: Josh Hawley

Re: SQL unavailable

Veeam Logoby Dima P. » Wed Jun 03, 2015 2:00 pm

P.S. Just do not forget to remove the said registry value once you are up and running – otherwise, it recreates database on every service restart. Thanks.
Dima P.
Veeam Software
 
Posts: 6242
Liked: 440 times
Joined: Mon Feb 04, 2013 2:07 pm
Location: SPb
Full Name: Dmitry Popov

Re: SQL unavailable

Veeam Logoby TroyResources » Mon Jul 13, 2015 1:21 am

Good morning, well this morning my end point reported the very same error.
Thanks for the solution.
After deleting the reg key is it advisable to restart server?
is this fixed in v1.1?

Also to ensure no lose of data I exported disk contents as VDMK for 5 day retention period.
TroyResources
Enthusiast
 
Posts: 34
Liked: 6 times
Joined: Tue May 26, 2015 7:44 am
Full Name: TroyResourcesLimited

Re: SQL unavailable

Veeam Logoby Dima P. » Mon Jul 13, 2015 1:41 pm

Hi,
this morning my end point reported the very same error

Anything changed in regards to your infrastructure? Windows updates or something similar?
After deleting the reg key is it advisable to restart server?

Add the key – Restart the service or restart the machine – Delete the key
is this fixed in v1.1?

We’ve made some improvements for sure.
Dima P.
Veeam Software
 
Posts: 6242
Liked: 440 times
Joined: Mon Feb 04, 2013 2:07 pm
Location: SPb
Full Name: Dmitry Popov

Re: SQL unavailable

Veeam Logoby TroyResources » Tue Jul 14, 2015 1:03 am

Hi @Dima,

Nothing in environment had changed, sorry very common support comment.
Backup is now working thanks to the post by DH.

Thanks for your input...
TroyResources
Enthusiast
 
Posts: 34
Liked: 6 times
Joined: Tue May 26, 2015 7:44 am
Full Name: TroyResourcesLimited

Re: SQL unavailable

Veeam Logoby Dima P. » Tue Jul 14, 2015 12:03 pm

Good, thanks! As I said before we’ve improved the database handling in the next version, so hopefully is going to cover issues like yours - let’s wait till it released and test it. Meanwhile, if you face this behavior again – please open the support case before recreating the database. Cheers!
Dima P.
Veeam Software
 
Posts: 6242
Liked: 440 times
Joined: Mon Feb 04, 2013 2:07 pm
Location: SPb
Full Name: Dmitry Popov

Re: SQL unavailable

Veeam Logoby TroyResources » Wed Jul 15, 2015 1:13 am

@ Dima, thank for feed back. If this scenario does present itself again I will certainly pen a support ticket.

Cheers!
TroyResources
Enthusiast
 
Posts: 34
Liked: 6 times
Joined: Tue May 26, 2015 7:44 am
Full Name: TroyResourcesLimited

Re: SQL unavailable

Veeam Logoby wkmiller » Fri Jul 17, 2015 4:09 am

Thanks for the post - one of the workstations was having this issue and the database recreate worked!
wkmiller
Lurker
 
Posts: 2
Liked: never
Joined: Tue Sep 17, 2013 10:09 pm
Full Name: wayne miller

Next

Return to Veeam Agent for Windows



Who is online

Users browsing this forum: No registered users and 10 guests