Comprehensive data protection for all workloads
Post Reply
widmerkarl
Expert
Posts: 122
Liked: 29 times
Joined: Jan 06, 2015 10:03 am
Full Name: Karl Widmer
Location: Switzerland
Contact:

Unable to detect database action - Upgrading Veeam to v9

Post by widmerkarl »

Hello everyone,

I'm trying to update Veeam Backup & Replication v8 to v9 at a customer. But it fails at the point where i have to specify the SQL database instance.

Error:
Unable to detect database action

At the first attempt i tried it with the existing database instance. The database of VBR v8 was set up on an existing SQL database instance, there was just created an additional database.

Then i tried to install SQL server 2012 R2 express and created a new database instance with its own database. Then i imported the backup file from the existing database into the new database on the new instance. When i run the setup again, the error persists.

Whats happening there? I'm not the SQL guru, so any help is appreciated.

Thank you very much!
Best regards,
Karl

-----------------------
vExpert 2017-2024
VMware VCP-DCV 2023 / VCA6-DCV / VCA5-DCV / VCA5-Cloud
Former Veeam Vanguard / VMCE v9 / VMTSP v9 / VMSP v9
Personal blog: https://www.driftar.ch
Twitter: @widmerkarl
Vitaliy S.
VP, Product Management
Posts: 27055
Liked: 2710 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Unable to detect database action - Upgrading Veeam to v9

Post by Vitaliy S. »

Karl, please include a case ID to your post, when creating a topic about technical issues. Thanks!
widmerkarl
Expert
Posts: 122
Liked: 29 times
Joined: Jan 06, 2015 10:03 am
Full Name: Karl Widmer
Location: Switzerland
Contact:

Re: Unable to detect database action - Upgrading Veeam to v9

Post by widmerkarl »

Hello Vitaliy,

I did not create a support case for this issue yet. I just wanted to find out if any person here in the forums had the same issue and if it has been solved. I did not find a related thread or post to this problem.

But if its necessary i'll open a support case and provide the case number here, no problem.

Thanks.
Best regards,
Karl

-----------------------
vExpert 2017-2024
VMware VCP-DCV 2023 / VCA6-DCV / VCA5-DCV / VCA5-Cloud
Former Veeam Vanguard / VMCE v9 / VMTSP v9 / VMSP v9
Personal blog: https://www.driftar.ch
Twitter: @widmerkarl
foggy
Veeam Software
Posts: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Unable to detect database action - Upgrading Veeam to v9

Post by foggy »

You seem to be the first to report this, so opening a case is indeed recommended.

Btw, have you tried just to perform a clean install letting the setup to install SQL Express locally and create the database automatically? Then you could import the configuration from your previous version.
widmerkarl
Expert
Posts: 122
Liked: 29 times
Joined: Jan 06, 2015 10:03 am
Full Name: Karl Widmer
Location: Switzerland
Contact:

Re: Unable to detect database action - Upgrading Veeam to v9

Post by widmerkarl »

Hi foggy,

Thank you. We performed a clean install, letting the setup install the SQL Express locally. We did nothing special, all log entries, job settings etc. were migrated without any action from our side (DB exports / imports or so).

So the problem is solved. But i'm wondering what produces this error message.

Should I now still a Support Case open, although the problem is solved?
Best regards,
Karl

-----------------------
vExpert 2017-2024
VMware VCP-DCV 2023 / VCA6-DCV / VCA5-DCV / VCA5-Cloud
Former Veeam Vanguard / VMCE v9 / VMTSP v9 / VMSP v9
Personal blog: https://www.driftar.ch
Twitter: @widmerkarl
PTide
Product Manager
Posts: 6408
Liked: 724 times
Joined: May 19, 2015 1:46 pm
Contact:

Re: Unable to detect database action - Upgrading Veeam to v9

Post by PTide »

Yes, please open a case with support so they can gather all required information that can be used to improve future versions.

Thank you.
widmerkarl
Expert
Posts: 122
Liked: 29 times
Joined: Jan 06, 2015 10:03 am
Full Name: Karl Widmer
Location: Switzerland
Contact:

Re: Unable to detect database action - Upgrading Veeam to v9

Post by widmerkarl »

Hello,

I've created a support case for this issue:

Case # 01676621
Best regards,
Karl

-----------------------
vExpert 2017-2024
VMware VCP-DCV 2023 / VCA6-DCV / VCA5-DCV / VCA5-Cloud
Former Veeam Vanguard / VMCE v9 / VMTSP v9 / VMSP v9
Personal blog: https://www.driftar.ch
Twitter: @widmerkarl
slider182
Novice
Posts: 3
Liked: 5 times
Joined: Feb 09, 2016 9:29 pm
Full Name: Manfred Sailer
Contact:

Re: Unable to detect database action - Upgrading Veeam to v9

Post by slider182 » 2 people like this post

Hello,

I recently had the same error message when trying to upgrade to v9.
In my case it was that the admin account with which the setup has been invoked had a roaming user profile.
Switching to a local user profile just for the upgrade solved the problem.
(Maybe something with folder redirection)

Best Regards,
Manfred
jim.montgomery
Novice
Posts: 9
Liked: never
Joined: Mar 06, 2015 2:52 pm
Full Name: Jim Montgomery
Contact:

Re: Unable to detect database action - Upgrading Veeam to v9

Post by jim.montgomery »

# 01784615

Trying simple upgrade from Veeam 8 to 9. Have done this for several clients and this time it failed with the vague unable to detect database action
Craigb
Influencer
Posts: 15
Liked: 28 times
Joined: Nov 14, 2012 2:28 am
Full Name: Craig Braithwaite
Contact:

Re: Unable to detect database action - Upgrading Veeam to v9

Post by Craigb »

I'm on the forums to find an answer for the same, or at least a closely related issue so I'll drop this here for now.
* This page >> https://helpcenter.veeam.com/docs/backup/vsphere/upgrade_vbr.html?ver=95 << has the checklist but it doesn't mention the sql database version as being a prerequisite.
* my upgrade is from 9.0_u2 to 9.5.0.823.Update1
* my error is >> SQL Server version TAPESVR\VEEAM is not supported: SQL Server 2008 (10.0.0.1600.22) or later is required. <<
* same as KawiMTF (the op), I'm not an expert in sql local instances so I'm currently hunting around for an upgrade proc from whatever I have to this unlisted pre-requisite.
Craigb
Influencer
Posts: 15
Liked: 28 times
Joined: Nov 14, 2012 2:28 am
Full Name: Craig Braithwaite
Contact:

Re: Unable to detect database action - Upgrading Veeam to v9

Post by Craigb »

-- best ignore that, I found the ref to sql2008 in the minimum specs area and it turns out I have 2005. This is not a veeam problem I guess.
Craigb
Influencer
Posts: 15
Liked: 28 times
Joined: Nov 14, 2012 2:28 am
Full Name: Craig Braithwaite
Contact:

Re: Unable to detect database action - Upgrading Veeam to v9

Post by Craigb »

If it helps anyone else who isn't sure how to proceed, this is one way that worked.

It starts when you get the error "SQL Server version Your-Server\VEEAM is not supported: SQL Server 2008 (10.0.0.1600.22) or later is required"

* Make an encrypted backup from the Veeam menu that includes creds for jobs.
(my jobs have various credentials, I'd say that's normal for most of us.)
- use top-left-hamburger -> configuration backup -> select the encrypted option.

highest sqlexpress that can run on 2008R2 is SQL-EXPRESS-2014, download and extract it.
theoretically it'll run and upgrade existing instances, but whines and exits so no.
uninstall sqlexpress 2005 ( 1 item, Veeam's database)
uninstall sql2008 (many items including VIM databases from 5.0, 5.5, and 6.0)
no more sql applications
no more sql instances.
uninstall VMware client - (I'll put it back later though)

.. Now install sql-express-2014
the name it asked for is the instance name so call it VEEAM
.. this creates an empty database with the same instance name that B&R is going to look for.
.. Fire up Veeam (inc starting stopped services) and use top-left-hamburger -> configuration backup -> restore
.. I chose 'restore because I migrated' however when that was nearly done the Veeam installer slapped me on the wrist and did the 'recover failed server' parts as well.

Everything is fine, all my jobs etc. are still there and Veeam B&R is now running on an sql-express-14 database.
- caveat.. all my normal jobs are disabled, so I enable them again.
- It's currently rereading every tape in the library, perhaps I could have taken most of them out first but there's not that many.
- wait for the tape reading operation to finish.
- enable relevant jobs

Checks
test a manually kicked off job ==ok
let a scheduled job run and ensure it kicks off ==ok
browse VSphere from Veeam to ensure certs/perms are good == ok.
write a tape == ok
now ..
- wait for clear time with no backup tasks.
- make a new spare Veeam database backup (because tonight's backups will change the real data)
- upgrade to 9.5
.... went straight through with no issues.

so.. hope it helps...
JRBeaver
Service Provider
Posts: 14
Liked: 3 times
Joined: Mar 30, 2017 9:09 pm
Full Name: John Beaver
Contact:

Re: Unable to detect database action - Upgrading Veeam to v9

Post by JRBeaver » 1 person likes this post

I know this is an old thread but I wanted to advise anyone who might get this issue with upgrading to Veeam B&R 10.

In my case folder redirection is being used and the folder location was changed, this change was not reflected in the path for all locations in the registry.

So the fix was to regedit - HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\User Shell Folders
Change any reference to the old location in any of these keys to the new location of your folder redirection, reboot the Veeam server and then run the upgrade again.

This resolved the error and Veeam upgraded to 10 without issue.
Regards
John B
Post Reply

Who is online

Users browsing this forum: Google [Bot] and 306 guests