We recently had an issue with Veeam B&R 4.1 that gave us the "Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints" error
Veeam Support told us we needed to uninstall and reinistall Veeam and also [install SQL Management Station and] delete the Veeam Database. This meant that all the jobs we had set up (60+ - one for each VM so that we can manually run each one) were all wiped out.
Is there any way that we can backup yp the Veaam server/database so that should this happen again we can roll the DB back to a working state?
Ric, yes you can backup Veeam SQL database just like any other SQL database, it is no special. For example, you can use backup capabilities which are built into the SQL management studio. Thank you.
We use a 3rd party product to backup SQL databases. I have tried to connect to our Veeam servers but am not getting a connection. I have enabled Named Pipes and also TCP/IP Protocols under SQL Server 2005 Config Manager but this has not worked. Can you help ?
Amit, for this issue you may want to open support call with that other backup product vendor instead... I am afraid we will not be able to help you in troubleshooting SQL connectivity issues in 3rd party backup product
I don't do anything special other than back up my Veeam VM like any other VM. I use SAN/NBD with automatic rollover, you CANNOT back it up in VA mode, it will crash your Veeam server and put the disks into persistent mode and set to ignore changes. Then when you power down the machine it reverts back. I've had this happen to me twice and have lost a month the first time and 2 weeks the second time until I figured out what the issue was.
For every expert there is an equal and opposite expert - Arthur C Clarke's Fourth Law