vSphere Data Protection 6 – Restore SQL data

I tried SQL backup and restore options in vSphere Data Protection 6, becouse this is a free backup solution from vmware, up from Essentials licence. I writed a post how can you install this application. You can see below.

Now i’m going to show you how be able to create a backup job, and how be able to restore your DB.

In my eximple, i created a db in my MS SQL server, and created one table.
After that i create a backup job, and made a backup from my db.
I deleted my table from SQL DB, and i restored that.

Backup part

VDP6-SQL-Backup-001
Create a new backup job
VDP6-SQL-Backup-002
Select Application option

You can choose Full and Selected DB. The diferent between two options are:
Full – This option is going to save your all DB on server
Selected DB – You will be able to select one or more specific DB on server

VDP6-SQL-Backup-004
Select DataBase

If you didn’t see your db under server, please scroll down legal of this page!

VDP6-SQL-Backup-005

VDP6-SQL-Backup-006

VDP6-SQL-Backup-007

Restore part

VDP6-SQL-Backup-008

VDP6-SQL-Backup-009

VDP6-SQL-Backup-010

VDP6-SQL-Backup-011

VDP6-SQL-Backup-012

VDP6-SQL-Backup-013

VDP6-SQL-Backup-014

!!! When you don’t see your database under the server, you can fix it, when you add right to SYSTEM user.

VDP_Fixed

One thought on “vSphere Data Protection 6 – Restore SQL data

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