How To - Handle the "Backup Database error" reported in Database Setup Tool

How To - Handle the "Backup Database error" reported in Database Setup Tool

How to handle the error " BACKUP DATABASE is terminating abnormally" reported in the Database Installer tool while upgrading to newer BME version (as shown below)?




Solution: 

1. In general, the DBInstaller tool takes a backup of the DB before performing update operation.

 

The above error typically implies that the 'Database administrator credentials' configured in the tool doesn't have sufficient rights to back up the database.

  • If you are using Windows authentication, then proceed to complete the BME installation with error and afterwards, re-login to windows with an account having administrator rights and then run the 'DBInstaller' from {BME installation directory}/Tools folder by choosing the 'Update' option again.
  • In case of 'Database server login credentials', ensure that the configured credentials has sufficient rights or configure a different user.

If there is no credential available with backup rights, then you have to manually take a backup, comment the backup section in database update script (TBS-update_db.sql) and run the DBInstaller tool again. The steps are provided below:

WarningNOTE: TBS strongly recommends performing a manual database backup before proceeding with the below steps. Should you choose to continue without a backup, please be aware that this is done at your own risk.
  1. Make a copy of the file TBS-update_db.sql  available under {BME installation directory}/Tools/DBInstaller/scripts folder.
  2. Open the original TBS-update_db.sql file in a text editor. 
  3. Locate and remove the comments between the highlighted lines — starting just after the line that says: "print 'Update Started ...'  and ending just before the line that says: "-- Start changing current database" . Then save the file.
           

  1. Run the DBInstallerTool again and choose the Update option.

  1. After the update is successfully completed, restore the original TBS-update_db.sql file (by using the copy made earlier) to maintain consistency for future updates.

    • Related Articles

    • HowTo - Handle 'Database operation error' issues

      The Database operation error issue is one of the most common problems detected after a WebEdition installation. It is a general error which is basically saying that connection to the database server (default, SQL Server) could not be established. ...

    • HowTo - Handle 'SOAP-ERROR: Parsing WSDL' error in BioManager

      BioManager reports error “SOAP-ERROR: Parsing WSDL” which means connection to RemoteAdmin WSDL resource failed. Solution This error is most of the times caused by: missing ‘WCF Services - HTTP activation’ component (under Windows Features - .Net 4.5 ...

    • HowTo - Handle HTTP Error 500.30 in BioManager

      BioManager reports error “HTTP Error 500.30 - ASP.NET Core App failed to start” when accessing it. The following error is reported on the web browser. Solution The error "HTTP 500.30 - ASP.NET Core app failed to start" can have multiple root causes. ...

    • FAQ - BME Database migration to another MS SQL Server

      Question How can I migrate the BME server database to another MS SQL server? How can I migrate the WebEdition database to another MS SQL server and update & connect to BME server? Answer This article describes how to move BME server database to ...

    • FAQ - Device error code description

      Question How to interpret the error codes reported on device and resolve them? Answer The following table provides brief description of device error codes. Error code Description Resolution 0 No error. 1 General error. 42 Sensor image caching (sensor ...