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

Which SQL to use?

Created: 18 Oct 2012 • Updated: 19 Nov 2012 | 2 comments
This issue has been solved. See solution.

Installing BE2012 on a Windows 2008 server that runs SQL Server 2008 as well.

Which method do you recommend to install BE2012?   Using the existing SQL installation,  or using BE's  SQL installation?

 

What are the pro's and con's of each?

Comments 2 CommentsJump to latest comment

AmolB's picture

Its always recommended to use BE's own inbuild SQL instance. You may install BE on a full

blown SQL server but do not host BE database with any other applications database coz

frequently there are updates that needs to be installed for BE which requries recycling of BE services

along with the SQL service. Only limitation of inbuilt SQL express instance would be the size of the 

database but its good enough for BE as the database does not grow to large extent.

Refer to below forum threads where user are adviced to use SQL express instance.

https://www-secure.symantec.com/connect/forums/moving-bexec-db-one-sql-server-another#comment-6905801

https://www-secure.symantec.com/connect/forums/backup-exec-2010-r3-sql-server-q#comment-5792451

SOLUTION
Sush...'s picture

Also if the existing SQL is not properly configured as per the needs to Backup Exec then there will be issues with functioning of Backup Exec.

Refer to the following technote to see such one issue

http://www.symantec.com/docs/TECH52258 : Backup Exec does not function properly if installed into an existing SQL instance that uses case-sensitive collation.

 

So it is recommended that Backup Exec should use a dedicated SQL instance.

 

Thanks,

-Sush...

Hope this piece of Information Helps you... and if it does then mark this response as Solution....!!!