FAQ - Database migration to another MS SQL server

FAQ - Database migration to another MS SQL server

Question
How can I migrate complete TBS WebEdition server database to another MS SQL server?

Answer
This article describes how to move TBS WebEdition server database to another MS SQL database server. This may be useful e.g. in case you are moving or upgrading your TBS WebEdition server to a new physical computer or when you need to separate MS SQL database server role to a dedicated computer.
  1. Backup the database of current server following the procedure described in Backup and restore of TBS WebEdition server database (MS SQL).
  2. Copy the backup file to a folder on the target computer.
  3. Start Microsoft SQL Management Studio on the target computer.
  4. Right click Databases node and select Restore Database… from the displayed context menu.
  5. Fill in “TBS_BAWSE” into To database: field, switch Source for restore to From device and click […]. In Specify Backup dialog, click [Add] and browse for your stored backup file.
  6. In Select the backup sets to restore list, select (check the box in Restore column) the item you added in the previous step. Click [OK] to start the process.
  7. When the database is restored, it is necessary to run a script to create correct login credentials for the restored database. To do so, select File -> Open -> File… in the main menu of MS SQL Management Studio and choose the location of ‘TBS_BAWSE_resolveloginafterrestore.sql’ file (located at {Web Edition installation folder}\_tools\DBinstallTool\scripts for R10.x or {Web Edition installation folder}\Core\db for R8.x). Run the script with [Execute] button (or F5).
  8. If the version of the TBS WebEdition server you are migrating the database from is lower than the version of a target server (you are migrating and upgrading the server in one step), you must also run ‘TBS_BAWSE_update.sql’. This ensures proper database format for the new TBS WebEdition server.


Once migration to the new SQL Server is established, it is important that the TBS application is routed to connect to the new database server. This means the database connection settings from {Web Edition installation folder}\Core\web.config file must reflect the new changes.


    • Related Articles

    • FAQ - WebEdition migration to another server machine

      Question How can I migrate the TBS WebEdition server software to another server machine? Answer This article describes how to migrate the TBS WebEdition (WE) server software to a different physical computer. The below steps should be followed in ...

    • FAQ - Basic backup/restore of WE database in the same MS SQL Server

      Question How can I simply backup and restore TBS WebEdition server database (in the same SQL Server installation)? Answer In order to prevent data loss, it is a good practice to regularly backup content of TBS WebEdition server database. This article ...

    • FAQ - Ways to access SQL Server in WebEdition

      Question By default WebEdition accesses SQL server database using 'SQL Server authentication'. How can I change that to 'Windows authentication'? Answer TBS server software is preconfigured to use 'SQL Server authentication' method when connecting to ...

    • HowTo - Prevent WebEdition database log file from expanding continuosly

      Question How can I reduce the file size of TBS WebEdition database log, default name 'TBS_BAWSE.ldf'? NOTE: This logging is an inbuilt feature of MS SQL server itself and not created by TBS software. Its the responsibility of local DB server ...

    • 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. ...