4 Replies Latest reply on Mar 18, 2013 7:31 PM by Josh26

    vCenter DB Corruption

    peter79 Enthusiast

      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. Re: vCenter DB Corruption
          yezdi Master
          vExpert

          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=2012138

          • 2. Re: vCenter DB Corruption
            Sreec Master
            Community WarriorsvExpert

            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?

            • 3. Re: vCenter DB Corruption
              gajuambi Enthusiast

              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

              • 4. Re: vCenter DB Corruption
                Josh26 Master

                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.