Backup Exec 2010 R3 & SQL Server Q
New to Symantec Backup Exec, have to do a fresh install tomorrow. Looks like I have a couple of options for the database backend... what do you think about the following:
1. Use the SQL Server Express 2005 instance (installed automatically). My only concern with this is database size and the fact that I can't use SQL server agent (can you think of any downsides to this?)
2. Install SQL Server Express 2008 R2. Just grab the latest version, create a Backup Exec instance, and tell the installer to refer to this instance.
3. Install SQL Server Standard 2008 R2. Larger database size, SQL agent (maintenance plans, scheduled tasks, etc.)...
Further, knowing almost nothing about Backup Exec, I assume you can (and should) backup the media catalog/database. Does Backup Exec 2010 R3 server include a license to backup the local SQL instance? If not, how does one backup this database?