Is a SQL Server Agent needed to protect the Backup Exec Media Server?

[sbitarchitect]

We're about to upgrade from BE 11d to 12.5 and wanted to know whether or not a SQL Agent was required to protect the BE Media Server.  Info that I found online suggested that it wasn't needed.  Could I get an "official" word on this?

Thanks.

[DR0701]

Hi there

If you're using a SQL Express instance on the same server as Backup Exec, then no, you don't need a separate SQL Server Agent.  Can't say for definite what the story is if you have MS SQL Server running on the same server though.

Hope this helps


Doug.

[Ben_L_]

You do not need to worry about backing up the SQL Databases for the Backup Exec provided instance.  Backup Exec performs a nightly backup at 4AM with the standard maintenance. As long as you are backing up the file system of the media server then you are backing up everything needed.  The file Backup Exec backs up the file to is located in the data directory of your install directory. The filename is BEDB.bak

If you were to backup the database with our SQL Agent you would not be able to restore the data since BE would not be able to overwrite it's own database while in use.  If you are using a remote SQL server and are backing up the database using the SQL Agent, in the event of a DR BE will need to be installed with the provided instance so that the database could be restored to the SQL Server. Then Backup Exec could be reconfigured to use the SQL Server BEDB.

--Ben