top of page
Writer's pictureRoman Lorenzen

Fix Veeam Backup and Replication if Database is Corrupt or Missing

Updated: Nov 20, 2022

If the Veeam Configuration Database is broken, missing or unreachable, so you cannot view the existing backups, this is how you temporarily fix this to make sure backups are still being taken.



This will only work if you have been taking backups of your Veeam Configuration. By default, this happens automatically. You can find the Backup DB Configuration in the actual backup folder found in your Backup Repository (where backups are saved).

Steps:

  1. Log into your Veeam Backup Server

  2. Run the Veeam Backup and Replication Configuration Database Connection Settings app (aka Configuration Database Connection Settings)

  3. Choose Veeam Backup and Replication and hit Next

  4. Enter a unique name for the database (example: VeeamBackup_2022-11-01) and change the server name to <VEEAM SERVER NAME>\VEEAMSQL2012_TMP (This database is located on the actual Veeam-Backup server) then hit Next


5. Next to apply the new DB to Veeam and click Finish

6. Open the Veeam Backup and Replication Console and Select Import Backup

7. Click Browse to find the backup you would like to restore

8. Enter the UNC of where the backup file is located

(example: \\Backup_Repository\d$\VEEAM\Administrative Servers - Per VM)

9. Choose the backup VBM file and click Open and then select OK

10. Enter the credentials you wish to use to import the backup

11. The backup jobs should now be listed under Backups


12. Once you have the original Veeam DB restored, follow steps 1-3 to change it back to the original database whenever it is available


Possible Issue:


If you cannot switch back to the old Veeam database because it is in use by another backup server, you will need to connect to the database using SQL Management and run the following query on the original Veeam backup database:

update dbo.options

set value = ''

wherename='lock_info'




71 views0 comments

Recent Posts

See All

留言


bottom of page