Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

local SQL Express DB

Created: 17 May 2010 • Updated: 19 Jun 2010 | 4 comments
This issue has been solved. See solution.

Hi

I installed BE 2010 on a server in one of our branch offices. For the database I chose the local SQL Express instance.
When I want to backup this SQL Express instance with BE, it tells me I need a license. Does this mean I need an license for a SQL agent for the local SQL Express database that is only used by BE? Is this new in BE 2010?
Would it be possible to create a DB dump with a tool like Microsoft SQL Server Management Studio Express and backup only this dump?

Thanks for the help.

Comments 4 CommentsJump to latest comment

RahulG's picture

To backup Any Sql database you need a Sql License.. But anyways your Backup exec Sql database is backed up every day when the database maintainance run( ie by default at 4 am ) .The dump of the database is  created a(bak file in the Data folder  )

SOLUTION
anyone's picture

Thanks for the hint about the bak file in the Data folder.
That's completely enough for me.

AmolB's picture

You may simply uncheck the SQL instance of BE  from the selection list of the backup job, as Rahul mentioned that Backup Exec runs the database maintenance everyday at 4am. So there is no need to backup the SQL instance through backup exec.

RahulG's picture

Please Mark the post as resolved if it has answered your query.. Cheers!!!