Video Screencast Help

upgrading SQL server 2008 express to SQL server 2008 R2 express

Created: 27 Mar 2013 | 12 comments

I'm am upgrading to SQL server 2008 R2 Express due to it having a larger size limit. Is this compatable with Symatec backup exec 2010 r3 and if so is there any precausions i should take? 

 

Thanks 

Operating Systems:

Comments 12 CommentsJump to latest comment

CraigV's picture

Hi,

 

BE 2010 R3 stops at SQL Express 2005 SP3 as a database on which to install the BEDB.

BE 2012 has supprot for SQL Express 2008 R2.

You can verify the first statement on the link below:

http://www.symantec.com/business/support/index?pag...

Thanks!

Alternative ways to access Backup Exec Technical Support:

https://www-secure.symantec.com/connect/blogs/alte...

VJware's picture

Pg 48 & 49 mentions that SQL 2008 (SP1 & SP2) & SQL 2008 R2 (including SP1) is supported as a database repository in BE 2010 R2 & BE 2010 R3

 

CraigV's picture

Thanks for the clarification...totally misread the query! Luckily it doesn't happen often wink

Alternative ways to access Backup Exec Technical Support:

https://www-secure.symantec.com/connect/blogs/alte...

resolver101's picture

Apparently i cant un-install the current version of SQL express due to windows needing it but i can install the R2 version along side it.  If I install SQL server 2008 R2 Express along side, should i move the database to the newer version? 

CraigV's picture

...if it can co-exist, and you want to make use of better features in it, then go for it. Just grab a copy of the Data/Catalogs folders, and specifically the bedb.bak file!

Thanks!

Alternative ways to access Backup Exec Technical Support:

https://www-secure.symantec.com/connect/blogs/alte...

resolver101's picture

Will i need the better features of SQL server for backup exec? I never view the data out of the Backup Exec anyway so I cant see it making any difference to me.

Jaydeep S's picture

SQL Server is not really required to host the BE database it can stay on a SQL Express version in the most complex of installations and work well. Also it is recommended to keep Be on its own seperate instance as any unsupported updates/changes done to you SQL Server instance can leave the Be in a not working state. To avoid changes to be made I would surely go with a SQL Express instance dedicated to BE (cheaper this way as well)

CraigV's picture

...I suspect that the OP meant SQL Express as this has been what was mentioned all along. May have been a typo!

Thanks!

Alternative ways to access Backup Exec Technical Support:

https://www-secure.symantec.com/connect/blogs/alte...

Jaydeep S's picture

Oh thanks! I think you are right. I was merely responding to "Will i need the better features of SQL server for backup exec?"

Edit - But all in all it is better to keep BE on a seperate instance as I have seen updates being applied to SQL instances by different products (Yes even SEP) can leave BE down.

VJware's picture

Usually, the only time when a different edition of SQL is required when the BEDB goes over 4GB limit (again which happens when using a large CASO-MMS or SSO setups) Else as suggested, the default SQL instance should be just fine.

CraigV's picture

...is your BEDB anywhere near the maximum size that SQL Express 2005 can handle? If not, then don't upgrade to SQL Express 2008 R2.

Alternative ways to access Backup Exec Technical Support:

https://www-secure.symantec.com/connect/blogs/alte...