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?
Discussion Filed Under:
Comments 2 Comments • Jump to latest comment
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
Amol
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....!!!
Would you like to reply?
Login or Register to post your comment.