In normal situation, taking backup of vCenter database from SQL server is straight forward and hassle free, little chances of corruption.
If there is something we've to be taken care it would have mentioned in the best practice guide or in the following KB.
Performing a backup wont corrupt a DB.There should be a strong reason why the Db got corrupted.What sort of corruption we had in the DB?
there isnt anything which is flawless and perfect and if it was then we wouldnt be having our jobs.coming to the point the chances of DB getting corrupt while taking backup are very minimal or i should say they are so rare that i havent heard anybody facing that problem. Backing up an SQL DB is very straight forward but if the DB is a VM you can take a snapshot and take a back up of the DB and then delete the snapshot or do the backup of the DB after the scheduled backup of the VM which has the DB in it to be on a safer side
I know this is a very broad question but I'm just curious, is it possible that during the backup process of a vCenter/SSO database, the databases actually get corrupted?
If you have a hardware failure of your storage system during the backup, your database may become corrupted. Of course, this would happen regardless of the backup process.