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.

Start here if you’re changing the server name, otherwise skip the SQL commands below:

Open command prompt and type the following:

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

Then proceed with tranferring your db over to the new server. Two folders under Backup Exec installation folder are needed: Data and Catalogs. 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_dat.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/attach your database and start your BE services automatically. If not then start them manually.

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.

Copyright © 2009 - All Rights Reserved
Information about how to reuse or republish this work may be available at Ali (Babusi) Aboosaidi.

Comments (6) Trackbacks (1)
  1. Nathan A. Clark
    11:37 AM on December 5th, 2009
    Internet Explorer 8.0 Internet Explorer 8.0 Windows Vista Windows Vista
    Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.0; WOW64; Trident/4.0; SLCC1; .NET CLR 2.0.50727; .NET CLR 3.5.21022; .NET CLR 3.5.30729; .NET CLR 3.0.30729)

    Thanks very much! Worked like a charm, even from 10.x to 12.x.

  2. jens
    1:29 PM on February 9th, 2010
    Firefox 3.5.7 Firefox 3.5.7 Windows XP Windows XP
    Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv: Gecko/20091221 Firefox/3.5.7 (.NET CLR 3.5.30729)

    thanks a lot! :)

  3. Danny
    5:31 AM on July 19th, 2010
    Firefox 3.6 Firefox 3.6 Windows 7 Windows 7
    Mozilla/5.0 (Windows; U; Windows NT 6.1; nl; rv:1.9.2) Gecko/20100115 Firefox/3.6

    If you are getting “Physical Volume Library Drive not available.” errors when running a backup job to a “Backup to Disk” device after this procedure, simply disable/enable the device and all should be well again… :)

  4. Roger
    2:20 AM on May 30th, 2012
    Google Chrome 19.0.1084.52 Google Chrome 19.0.1084.52 Windows XP Windows XP
    Mozilla/5.0 (Windows NT 5.1) AppleWebKit/536.5 (KHTML, like Gecko) Chrome/19.0.1084.52 Safari/536.5

    Hi. Has anyone tried to import a 10.x configuration file to BE 2012? (Which is version 14 and not 12.x)

  5. Ali
    9:31 AM on May 30th, 2012
    Firefox 12.0 Firefox 12.0 Windows 7 x64 Edition Windows 7 x64 Edition
    Mozilla/5.0 (Windows NT 6.1; WOW64; rv:12.0) Gecko/20100101 Firefox/12.0

    I didn’t. Upgrade worked well, though.

  6. Ali
    11:50 PM on June 8th, 2012
    Wordpress App 2.1.2 Wordpress App 2.1.2 Android 2.1.2 Android 2.1.2

    Thanks for warm comment. It made my night. Glad it worked for you.

Leave a comment