Impossible to restore configuration

Availability for the Always-On Enterprise

Impossible to restore configuration

Veeam Logoby pantoufle » Tue Mar 08, 2016 6:03 pm

My installation was old, and was upgraded on each new release.

today, it is Veeam 8 U3 installed on Windows 2008...

it's time to think about an OS upgrade. (2012r2)

during Moving of my Veeam Services from old to new server ( following Veeam KB 1889 )

i have an error during configuration restore.

Code: Select all
3/8/2016 5:26:39 PM          Connecting to database VeeamBackup
3/8/2016 5:26:40 PM Error    Reading configuration backup
3/8/2016 5:26:40 PM Error    Restoring configuration catalog (0% done)
3/8/2016 5:26:41 PM Error    Invalid object name 'Track_changes'.
3/8/2016 5:26:41 PM Error    Cannot read configuration backup.
3/8/2016 5:26:41 PM Warning    Failed to restore configuration
3/8/2016 5:26:41 PM Warning    Veeam Backup and Replication has been stopped



and this problem occur on 3 of my 4 Veeam infra :-(

i hope it is due to an old bug present in my database.

Case id = 01721232

does exist a tool to check Veeam configuration ?
pantoufle
Novice
 
Posts: 9
Liked: never
Joined: Thu Feb 16, 2012 6:20 pm
Full Name: Pantoufle

Re: Impossible to restore configuration

Veeam Logoby Dima P. » Tue Mar 08, 2016 6:26 pm

Hi pantoufle,

To clarify, does your newly installed VBR server have the same build number with the original server, for example does it have the latest update installed (v8 u3)?
Dima P.
Veeam Software
 
Posts: 6231
Liked: 439 times
Joined: Mon Feb 04, 2013 2:07 pm
Location: SPb
Full Name: Dmitry Popov

Re: Impossible to restore configuration

Veeam Logoby pantoufle » Wed Mar 09, 2016 8:22 am

yes of course, 8 u3 on both side.

support respond to me yesterday night.

i check and give you more information ;-)
pantoufle
Novice
 
Posts: 9
Liked: never
Joined: Thu Feb 16, 2012 6:20 pm
Full Name: Pantoufle

Re: Impossible to restore configuration

Veeam Logoby pantoufle » Wed Mar 09, 2016 9:28 am

Hi,

Configuration restore error is due to an old "no more used" table in our Veeam Database ( "Track_changes").
probably not "dropped" during upgrade from Veeam 4 to 5 ( said support ).

veeam enginneer give me some instructions and all is working fine.

i don't know if i can give those instructions here ;-)

Many Thanks.
pantoufle
Novice
 
Posts: 9
Liked: never
Joined: Thu Feb 16, 2012 6:20 pm
Full Name: Pantoufle

Re: Impossible to restore configuration

Veeam Logoby foggy » Wed Mar 09, 2016 12:47 pm

We do not encourage our customers to manually perform such database changes, so they'd better contact support directly for assistance, if required.
foggy
Veeam Software
 
Posts: 14728
Liked: 1076 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: Impossible to restore configuration

Veeam Logoby MarchBrown » Thu Dec 15, 2016 7:21 pm

While support doesn't encourage customers making these changes I'll post the procedure for those encountering this issue who may not have an active support contract.

1. Open SQL Management Studio
2. Connect to your Veeam SQL instance (varies by original install options chosen)
3. Backup the VeeamBackup database to your preferred location.
4. Expand the VeeamBackup database in Object Explorer
5. Expand the Tables sub item in Object Explorer
6. Locate the Track_Changes table
7. Right click the Track_Changes table and choose Delete
8. Re-run the Configuration backup to capture the change
9. Move the configuration backup to the new server and restore/migrate as per support documents.

The only caveat is that you must logon to SQL using an account with SA level access.
MarchBrown
Novice
 
Posts: 6
Liked: never
Joined: Fri Sep 18, 2009 1:24 pm


Return to Veeam Backup & Replication



Who is online

Users browsing this forum: Google [Bot], v.Eremin and 39 guests