VMware Cloud Community
peter79
Enthusiast
Enthusiast
Jump to solution

vCenter DB Corruption

Guys,

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?

I guess I'm trying to figure out if there is "best practice" for backing up the DB's (full MSSQL DB not default DB bundled with vCenter).

1 Solution

Accepted Solutions
Sreejesh_D
Virtuoso
Virtuoso
Jump to solution

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.

http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=201213...

View solution in original post

Reply
0 Kudos
4 Replies
Sreejesh_D
Virtuoso
Virtuoso
Jump to solution

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.

http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=201213...

Reply
0 Kudos
Sreec
VMware Employee
VMware Employee
Jump to solution

Hi ,

    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?

Cheers,
Sree | VCIX-5X| VCAP-5X| VExpert 7x|Cisco Certified Specialist
Please KUDO helpful posts and mark the thread as solved if answered
Reply
0 Kudos
gajuambi
Enthusiast
Enthusiast
Jump to solution

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

---------------------- Gajendra D Ambi [pardon my chat lingo]
Reply
0 Kudos
Josh26
Virtuoso
Virtuoso
Jump to solution

peter79 wrote:

Guys,

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?

Yes.

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.

Reply
0 Kudos