Veeam v6.5 (database issue)

Today I came across a problem with Veeam v6.5. I had recently upgraded it from either v6.0 or v6.1 and since the upgrade all of the jobs had failed with the error message “cannot complete login due to an incorrect username or password”.

image

I knew that the username and password hadn’t changed recently but just to be certain I re-entered them into Veeam and removed and re-added the VM to the backup job but both of these efforts proved fruitless. After a quick Google I discovered that this was a common problem when upgrading to v6.5, for some reason the SQL database that Veeam uses get duplicated in the hosts.db table. I found this website and followed the numbered points, and with a bit of trial and error managed to get Veeam working again. Here is what I did…

 

    1. Backup Veeam database.
    2. Stop Veeam services.
    3. In SQL Management Studio try to delete the duplicates that you think are causing the problem.

Screen shot of the original table…

image

  1. I originally deleted all rows apart from 3, 5, 8 & 10.
  2. Restarted SQL instance & started Veeam services.
  3. Then re-tried one of the backup jobs, but got this error…image
  4. So I stopped Veeam services, and restored database from the backup made in stage 1.
  5. Re-deleted the rows but this time kept the row with the fe66f766… host ID too…image
  6. Restarted SQL instance & started Veeam services .
  7. Then re-tried one of the backup jobs, but got this error…image
  8. So stopped Veeam services, and restored database from the backup made in stage 1.
  9. Re-deleted the rows but this time kept the row with the 831d14e8… host ID (and 545b0af0… because that looked very similar too).
  10. Restarted SQL instance & started Veeam services.
  11. Then re-tried one of the backup jobs, and it worked!!

image

Screen shot of hosts.db table afterwards…

image 

Veeam Backup & Replication 6.5

Veeam have announced v6.5 of their popular Backup & Replication program. As with most Veeam updates, they add some great new features, see the quick overview below.


The most notable new features for us in v6.5 are:

Free e-discovery and item recovery for Microsoft Exchange. Basically now even the Standard version of Veeam has item level recovery for Exchange. This is a welcome feature, and has greatly simplified the dreaded task of recovering mail. See a quick demo below, of just how easy it now is to restore a single item from a backup.

New hypervisor support: VMware vSphere 5.1 and Windows Server 2012 Hyper-V. This is a welcome addition, as Server 2012 Hyper-V is looking to be a fantastic product that we’ve already started using in production.

Click here for more info on Veeam Backup & Replication 6.5