How can I import\restore a Backup Exec Database to a different system
I have been running Backup Exec 11d in Windows SBS 2003 and am moving to Backup Exec 12.5 in Windows 2003 R2. SQL Express 2008 is running in the SBS server and SQL Server 2008 R2 in the Windows 2003 R2 server.
I would like to be able to restore the backup of the SQL 11d database into the server running 12.5. Is this possible and if not straightforward how?
The purpose is to be able to do a restore without first having to catalogue a tape. I have over 100 tapes in an archive and do not know where the next restore request will come from.
You cannot use Server 2008 R2 as a media server for BE 12.5. Neither does it support SQL 2008 R2. Again you need BE 2010 for both of that. See the SCL's below
BE 2010|2010 R2|2010 R3 Software (SCL)
You can do an in-place upgrade directly from BE 11d to BE 2010 R3 which is the latest version. This will preserve your existing jobs and catalogs. Make sure that you make a copy of the Data and Catalog directories under the BE installation directory, in case the upgrade goes wrong. After the upgrade, you should run LU a couple of times to install SP1 and the latest hotfixes. The upgrade to BE 2010 is free if you are on a current maintenance contract.