How to Move backup exec 2010 R2 sql DB to SQL 2008
Hello;
At present we are planning to move symantec backup exec 2010 SQL DB to the Sql 2008. the sql 2008 will be install on the same server & after migrating database, we will remove the sql express 2005 . below are the product details
1- Backup exec 2010 R2 x 4 with central admin x1
2- Licenses:
# | SYMC BACKUP EXEC 2010 AGENT FOR WINDOWS SYSTEMS WIN PER SERVER BNDL STD LIC GOV BAND S ESSENTIAL 12 MONTHS | 6 |
# | SYMC BACKUP EXEC 2010 OPTION CENTRAL ADMIN SERVER WIN PER SERVER BNDL STD LIC GOV BAND S ESSENTIAL 12 MONTHS | 1 |
# | SYMC BACKUP EXEC 2010 OPTION SAN SHARED STORAGE WIN PER SERVER BNDL STD LIC GOV BAND S ESSENTIAL 12 MONTHS | 6 |
i need best preactice guide, links to do the above task
Thank You,
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.