Updating catalogs backup exec 2016
Even though I tried taking the and recovering it, then I tried upgrading the schema via which is supposed to fix the database and insert the new schema in it along with all its tables and views yet at a certain point it fails because it can’t find a certain column.So eventually you will have to return into a blank database and start all over. 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.After the form '@name = value' has been used, all subsequent parameters must be passed in the form '@name = value'.20 120 The select list for the INSERT statement contains fewer items than the insert list.
Two folders under Backup Exec installation folder are needed: Data and Catalogs.Variable names must be unique within a query batch or stored procedure.35 135 Cannot use a BREAK statement outside the scope of a WHILE statement.After backing up your current folders: Stop all Backup Exec services. In the left pane click on All Media Servers, and in the right pane right click on your server name and click Copy Database.I’d open the console and go to Tools – Backup Exec Services and stop all. Copy the above folders to your new server and overwrite all existing files. You will be prompted not to use the utility without supervision… Browse to bedb_(database file) and bedb_(database log file) you just copied over from the old server. BEUtility will transfer your settings and detach/attach your database and start your BE services automatically. 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.