05-28-2014 01:40 AM
Hi!
I want to avoid backing mssql databases twice (vmware backup + full MS SQL backup). And since it's now possibe to use application protection in vwmware backups, I want to make Vmware full backup with apl.prot.+ mssql incrementals (Full differential).
However I'm getting errors: "Cannot perform a differential backup for database, because a current database backup does not exist."
The netbackup SQL client shows the backups from the full vmware backup (vmware database image backup).
Am I doing something wrong or is it not possible?
Solved! Go to Solution.
06-03-2014 07:55 AM
The 'normal' MS SQL database 'Full differential' backup would require prior Full backup taken using normal MS SQL policy.
05-28-2014 02:22 AM
Does your application protection backup truncate the SQL logs ?
This could be because the first SQL log is from before the full backup taken with the application protection
Don't know if what you are trying to do is possible, think SQL guide section about snapshot backup might be able to hekp you with that
05-28-2014 05:14 AM
From SQL guide
"VMware incremental backups of SQL Server are not supported with this version of NetBackup. However, the use of Accelerator may increase the speed of full backups."
05-28-2014 05:20 AM
Well yes, but I don't want to make the incremental backup by using vmware backup. I want to make a incremental backup by "normal" MS SQL backup policy.
2 different polices:
1. VMware full with application protection
2. Mssql incremental backup (from database only)
05-28-2014 05:33 AM
You'll have to use regular SQL agent backups then. Restores from VMWARE SQL backups only allow you to restore to recovered mode, so you won't be able to apply logs to a full restore.
06-03-2014 07:55 AM
The 'normal' MS SQL database 'Full differential' backup would require prior Full backup taken using normal MS SQL policy.