Veeam – How to backup/restore the VMware vCenter Server Appliance

To backup/restore the VMware vCenter Server Appliance (VCSA) with an embedded database using Veeam follow the below instructions Backup To backup the VCSA with Veeam, it’s important to understand that Veeam does not directly support Postgres SQL (VMware’s embedded DB). Instead, it’s optimal to perform backup in 2 parts: Part …

VMware vCenter Server 6.5 – Unable to upload files to datastore

When using VMware vSphere 6.5 with self-signed certificates, I noticed that I could not upload files to a datastore. This is due to the fact that the self-signed certificate is not trusted in the browser you are using. To resolve the issue follow the below steps (See also https://kb.vmware.com/s/article/2147256): Go …

VMware – SQL script to create the vCenter 4.1 database

use [master] go CREATE DATABASE [VCDB] ON PRIMARY (NAME = N’vcdb’, FILENAME = N’C:\Program Files\Microsoft SQL Server\MSSQL10.VIMSQL\MSSQL\DATA\VCDB.mdf’, SIZE = 2000KB, FILEGROWTH = 10%) LOG ON (NAME = N’vcdb_log’, FILENAME = N’C:\Program Files\Microsoft SQL Server\MSSQL10.VIMSQL\MSSQL\DATA\VCDB.ldf’, SIZE = 1000KB , FILEGROWTH = 10%) COLLATE SQL_Latin1_General_CP1_CI_AS go use VCDB go sp_addlogin @loginame=[vpxuser], @passwd=N’@Password’, …

VMware – Investigating the health of a vCenter database server

For troubleshooting purposes it may be necessary to verify the health of the VirtualCenter database server. This VMware article provides steps to eliminate the common causes for problems with a database server, including full disk space, transaction log maintenance, index fragmentation and other common database problems.