cancel
Showing results for 
Search instead for 
Did you mean: 

Moving Backup Exec from SQL 2008 R2 to local SQLExpress

Hello,

System overview:

BKP01 - Backup Server running WS2008 R2 Enterprise SP1 x64 with Backup Exec 2014 Version 14.1 Rev. 1786 (64-bit)

SQL01 - SQL Server running WS2008 R2 Standard SP1 x64 with MS SQL 2008 R2 (Fully patched)

Current SQL Server instance: SQL01\MSSQLSERVER

 

I would very much like to move the BEDB to BKP01. Currently SQLExpress is not installed on BKP01.

I also am planning an upgrade BKP01 to BE 15 if that will give me a path to move the DB.

Any advice welcome.

7 Replies

BE makes a nightly backup of

BE makes a nightly backup of the BEDB (bedb.bak). if you copy this to the new server and install a blank BEDB, you should be able to use beutility.exe there to reload the BEDB from a backup. Just point it in the direction of where you copied bedb.bak.

Upgrading​ the target server will also allow you to move the server config from the old server to the new server.

https://support.symantec.com/

https://support.symantec.com/en_US/article.tech67768.html

Which version & edition of

Which version & edition of SQL will you be using on BKP01 ?

The version with BE2014 or if

The version with BE2014 or if not possible as this will be SQLExpress 2005 I think then the SQLExpress version with BE 15.

This article deals with the

This article deals with the moving of the BE instance. I want to focus on moving only the BEDB.

Can you maybe point out the section in the article you think covers this?

It will be better to use

It will be better to use atleast the same version of SQL or higher on the BKP01 server and i don't think its supported to move the SQL DB from a higher version of SQL to a lower version.

First you'll have to install a SQL instance on the BKP01 server and then you can use BEutility to move the BEDB - https://support.symantec.com/en_US/article.TECH37752.html

I will investigate this

I will investigate this solution and get back to you.