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
Create a new backup job
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
Select DataBase
If you didn’t see your db under server, please scroll down legal of this page!
Restore part
!!! When you don’t see your database under the server, you can fix it, when you add right to SYSTEM user.
I found a good article from Tintri.