How to Move backup exec 2010 R2 sql DB to SQL 2008

Hi,

Check the TN below:

http://www.symantec.com/business/support/index?page=content&id=TECH37752

Thanks!

Ok bearing in mind we recommend BE always has it's own instance a quick and dirty method to change to SQL 2008.

1) Stop the BE services and the Backup Exec SQL instance. (on all servers if using SSO/CASO)

2) Copy the Backup Exec\Data folder to somewhere safe. (this is just in case something goes wrong)

3) Uninstall the Backup Exec SQL Express instance (but do not uninstall Backup Exec)

4) Install SQL 2008 as an instance called BKUPEXEC (this must match the instance name of the 2005 instance that you uninstalled so if it was not BKUPEXEC make sure you know what it is and use that name)

5) Make sure all of the network protocols are enabled against this new SQL instance

6) Use SQL Studio to attach the BEDB located in the Backup Exec\Data folder into the new SQL 2008 instance

By keeping the instance name the same you should not have to repoint any registry settings for paths and instance names etc which should allow everything to start up as before.