Forum Discussion

Kingston's avatar
Kingston
Level 4
13 years ago

Agent for Apps & DB - mandatory?

Hello, We have some SQL servers and a Sharepoint server. Using BE 2012 . Wondering whether having the Agent for Apps & DBs is required to perform a successful backup of our SQL and Sharepoint S...
2012
Agents
Backing Up
Backup and Recovery
Backup Exec
  • pkh's avatar
    pkh
    13 years ago

    Since you are willing to restore the entire VM, then there is no need for the agent for DB and apps licence.  If you decide later on that you need granular restore, then you can add in the licence.  When you back up the VM, you can still restore single file/folder when you install the remote agent in the VM, but not applications or DB.  With the AVVI/AMHV licence, you are entitled to install remote agents in any number of VM's on the physical host which is licenced.

CraigV's avatar
CraigV
Moderator
13 years ago

Hi,

 

If you want to do live restores into an SQL DB, then the agent will help with this.

If not, you can do a backup of the entire VM (you need RAWS to do file-level restores), but you might not get backups of the *.mdf files etc. BE has Active File Exclusion which would exclude those files during a normal backup.

In this case, schedule a backup of the SQL DBs using SQL's backup utility.

THe thing to consider is whether or not you'd ever need to restore into SQL/Sharepoint, and weigh up the cost of getting the DB agent vs. doing it 2 or 3 times longer with multiple steps.

If you have the cash available, get the agents...

Thanks!