Ali Aboosaidi Umm… Unorthodox?

Backup Exec: Transfer scheduled jobs, database and settings to a new backup server

My db server crapped out so I’ll have to retype the whole darn thing

Well… it’s quite easy especially if you are keeping the same server name (skip the SQL commands below and go right to transfer section). If not you will have to change your SQL instance name accordingly.

If you’re changing the server name:

Open command prompt and type the following:

osql -E -S servername\BKUPEXEC
use bedb press enter
UPDATE DataPartition SET PartitionName='SERVERNAME' WHERE PartitionID = 0 press enter
SELECT partitionname FROM datapartition press enter
go press enter

Then proceed with tranferring your db over to the new server. Two folders under Backup Exec installation folder are needed: Data and Catalog. After backing up your current folders:

1. Stop all Backup Exec services. I’d open the console and go to Tools – Backup Exec Services and stop all.
2. Stop all SQL services in services console.
3. Copy the above folders to your new server and overwrite all existing files.
4. Run BEUtility.exe under Backup Exec folder. You will be prompted not to use the utility without supervision… right! Just click it away.
5. In the left pane click on All Media Servers, and in the right pane right click on your server name and click Copy Database.
6. Browse to bedb_data.mdf (database file) and bedb_log.ldf (database log file) you just copied over from the old server.
7. Click OK and proceed with the transfer.

BEUtility will transfer your settings and detach/reattach your database accordingly. I don’t recall whether or not BEUtility.exe will start your BE services automatically. If so you will see it happening in the same window. Start them manually otherwise.

If you don’t see an error message about unsuccessful db detach/attach and your services start in timely fashion then you should be able to see all your jobs, media, devices and even settings and encryption keys transferred to the new server.

Related posts:

1. Debian: Symantec Backup Exec 12 and Debian Etch 32/64
2. mySQL: How to backup/restore SQL databases through SSH
3. VMware ESX and ESXi – tips and tricks