2 Replies Latest reply on May 18, 2018 1:14 AM by ngwendk

    Replace a VCenter 5.5 SQL database with a new\fresh one

    ngwendk Novice

      Hi all, pls assist\advise. We have a VCenter 5.5 platform (the vcenter services are running on one server, and its sql database is running on another different server). The server that is hosting the vcenter sql database has crashed, and cannot be recovered, we did not even have database backups prior to the crash. Now, only the server running vcenter services remains. Is there, or is it possible to just create a new sql database? and point the existing vcenter services server to a newly created sql database? or even a newly created sql-express database?

        • 1. Re: Replace a VCenter 5.5 SQL database with a new\fresh one
          a.p. Guru
          Community WarriorsUser ModeratorsvExpert

          Not sure (I've never tried this), but I doubt that this is possible. The vCenter setup procedure initializes the database, and add content to it, and I don't think that the services will work without this.

          In this situation, I'd recommend you reinstall vCenter Server, or - even better - deploy the vCenter Server Virtual Appliance, since VMware plans to drop the Windows based version in a future version anyway. Also remember that version 5.5 will run out of general support in September.

           

          André

          • 2. Re: Replace a VCenter 5.5 SQL database with a new\fresh one
            ngwendk Novice

            Thank you very much André, much appreciated. I thought as much, i suspected that this might not work since the VC config is largely stored in the database.

            Yes, we are busy looking at upgrading all our VMware platforms to vSphere 6.x. Thanks again for advise...