VMWare Backup with Agent installed cause SQL backup
Backup Exec 2012 R3, all patch.
We are backuping our sharepoint infra thru the sharepoint agent. In the policy, we are doing:
· a weekly full database backup
· a daily differential database backup
· a daily logs backup
We were also doing VM backups with another policy:
· VM Full backup on a weekly basis
· VM incremental on a daily basis
The VM daily backup is causing a major problem; as the agent is installed on this server because of the need of SQL backup, the VM backup is causing a SQL full backup. This is caused by BeVSSProvider, and seems to be as by-design.
This SQL backup is leading to a error:
Final error: 0xe0000363 - The Backup Exec SQL Agent was not used to create the last full, differential, or log backup of this database. You must use the SQL Agent to run a full backup before you can run a differential backup or transaction log backup. http://entced.symantec.com/entt?product=BE&version=13.0.5204&module=eng-no_fs-backup&error=V-79-57344-867&language=EN&build=Retail
As a workaroud, I changed the VM policy and choose to backup the VM once a week with a full backup, which runs between the last SQL Log backup and the SQL weeky Full backup.
Were we wrong in the way of backuping also the VM on a incremental daily basis? Or is it possible to avoid BeVssProvider to backup SQL (I think for having the system quiesced)?
Thanks in advance.
Comments 2 Comments • Jump to latest comment
You can change the BE provider such that it will do a copy and thus not interrupt the SQL backup sequence. See Colin Weaver's comment in this discussion
https://www-secure.symantec.com/connect/forums/vm-...
and this document
http://www.symantec.com/docs/HOWTO74082
Thanks a lot pkh and sorry for the delay.
Adding the -copy flag let me do a log backup everyday!
Would you like to reply?
Login or Register to post your comment.