Backing up a VC

[khughes]

The managers above me are wanting to file level backup our virtual center server / SQL database since it's a physical box. For one, we are running another small sql database which we do need to backup but I was wondering if there were any quirks we should know about, or files which should or should not be included in our backup. We are running Veritas for our file level backups.

Thanks

[java_cat33]

Hi - running a full backup of the VC database (via Veritas using the SQL agent) will do the trick. I assume this server is also the ESX license server? Don't forget to backup the license file...

[Rodos · Accepted solution]

The just released whitepaper VirtualCenter Database Maintenance has a whole section on backup and recovery. There are a lot of topics cover and it will be well worth your read. Topics include

1. Scheduling Regular Backups

2. What You Need to Restore the VirtualCenter Server and Database After a Disaster.

3. Steps for Backup and Recovery of the VirtualCenter Database

4. Creating a Backup of the VirtualCenter Database

5. Restoring a Backup Copy of the VirtualCenter Database to a Different Server

6. Creating a Login for an Existing VirtualCenter Database User

7. Reassociating the VirtualCenter Database User and Login

8. Finding Orphaned VirtualCenter Database User Names

9. Testing the VirtualCenter Database User

10. Reestablishing the VirtualCenter System DSN to Use a Restored Database

11. Installing a New Instance of VirtualCenter to be Used with an Existing Database

Considering awarding points if this is of use

[khughes]

Thanks guys for your input