Upgrading vSphere 5.1 to vSphere 5.5- Part 2 Database and SSL Certificates Backup


Before proceeding with upgrading vCenter 5.1 to vCenter 5.5, taking backup of the VC database and SSL certificates are very important so that if anything goes wrong we can revert back to original configuration anytime.

Database backup can be taken by you yourself or by your DB admin depending upon the type of environment where you are working. Generally in big corporates there are separate team which do all the DB activities, however, as a vSphere Admin you should know how to do basic DB activities. Backing up DB is very simple and straight forward task. I will walk through all the steps in this post to make it easier and simple to understand. So let’s start!!!

Before proceeding with taking backup we need to identify the SQL server name and Database Instance Name of your vCenter server database.

How to find out DB instance name

RDP to the server where your vCenter DB is installed and go to Start > Administrative Tools > Data Sources (ODBC) connections and launch ODBC Data Source Administrator.

db1.1

Click on System DSN and then select Configure as shown below.

db1.2

Click Next

db1.3

Select how SQL server will verify authenticity of Login ID and Click Next. I usually prefers windows authentication but it may be different as in case of your environment.

db1.4

In the next screen select your DB name from Change the Default database drop down menu.

db1.5

Click Next and click finish on the next screen.

db1.6

Now since you have the name of your DB instance, it’s time to take backup.

To take backup of VC DB you need SQL Server Management Studio installed on the server where DB is installed. If you don’t have it installed (as in my case) then first we have to install it before proceeding further.

Download the appropriate version of SQL Server management Studio from Microsoft.com. Launch the installer by double clicking it.

db1.7

db1.8

db1.9

In the SQL Server Installation Center window select “New installation or add features” option as shown below.

db1.10

Next select “New Installation or add shared features”

db1.11

Select Management Tools option in next screen.

db1.12

Accept the license agreement and click next.

db1.13

You can skip the error reporting if you want (as it is my home lab)

db1.14

Sit and relax and let the installation complete.

db1.15

db1.16

Next screen shows the completion of installation of SQL Server Management Studio.

Hit close and you are done.

db1.17

After installation is complete launch the Management Studio from All Programs.

db1.18

Select the SQL server instance name from the server name drop down menu.

db2.1

Click on Browse for more if your vCenter DB instance name is not visible.

db2.2

Select Network Servers tab and locate your DB instance and click OK.

db2.3

Finally the screen should look like as shown below. Click on connect.

db2.4

Expand the Databases option and select your DB instance name and right click it and select Tasks > Backup

db2.5

A default Path in C:/Program file…..will be listed as place where backup file will be stored. You can define your own custom directory where you want to take backup by clicking on Add button on below screen.

db2.6

Navigate to the directory where you want to keep your DB backup, as shown below.

db2.7

In my case I created a directory named VC-DB-BKP in C drive. In file name field specify the name of the backup file and click ok.

db2.8

Next screen will look like as below. Hit OK to start taking backup.

db2.9

After completion of backup a dialogue box will pop stating backup has been completed successfully, as shown below

DB3.0

Verify the existence of backup file by navigating to directory specified for storing DB backup.

db3.1

Next is to take backup of the vCenter Server SSL certificates before Upgradation. Below is the location of the SSL certificates on the vCenter server.

Windows 2008: C:\ProgramData\VMware\VMware VirtualCenter\SSL

db3.2

Now we have completed the backup of vCenter server database and the SSL certificates. In the next posts of this series we will walk through:

Upgrading vCenter SSO

Upgrading vCenter Inventory Service

Upgrading vCenter Server

Upgrading vSphere Web Client

Hit Like or Rate this article if it is informative to you.

About Alex Hunt

Hi All I am Manish Kumar Jha aka Alex Hunt. I am currently working in VMware Software India Pvt Ltd as Operations System Engineer (vCloud Air Operations). I have around 5 Years of IT experience and have exposure on VMware vSphere, vCloud Director, RHEL and modern data center technologies like Cisco UCS and Cisco Nexus 1000v and NSX. If you find any post informational to you please press like and share it across social media and leave your comments if you want to discuss further on any post. Disclaimer: All the information on this website is published in good faith and for general information purpose only. I don’t make any warranties about the completeness, reliability and accuracy of this information. Any action you take upon the information you find on this blog is strictly at your own risk. The Views and opinions published on this blog are my own and not the opinions of my employer or any of the vendors of the product discussed.
This entry was posted in vSphere Upgrade. Bookmark the permalink.

5 Responses to Upgrading vSphere 5.1 to vSphere 5.5- Part 2 Database and SSL Certificates Backup

  1. Pingback: Upgrading vSphere 5.1 to vSphere 5.5- Part 1 Basics | Go Virtual.

  2. Pingback: Upgrading vSphere 5.1 to vSphere 5.5- Part 3 Upgrading SSO | Go Virtual.

  3. Pingback: Upgrading vSphere 5.1 to vSphere 5.5- Part 5 Upgrading vCenter Server | Go Virtual.

  4. Pingback: Upgrading vSphere 5.1 to vSphere 5.5- Part 6 Upgrading vSphere Web Client | Go Virtual.

  5. Pingback: Upgrading vSphere 5.1 to vSphere 5.5- Part 4 Upgrading Inventory Service | Go Virtual.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s