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

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 describes the backup procedure as well as steps needed to restore the backup file back, but in the same SQL Server installation. If you are interested to restore into another SQL Server instance, you may check out this article: https://help-center.tbs-biometrics.com/portal/en/kb/articles/faq-migration-of-tbs-webedition-database-to-another-ms-sql-server 

You will need Microsoft SQL Server Management Studio installed on your TBS WE server computer. The tool is a part of MS SQL server installation or can be downloaded for free directly from Microsoft's web site (https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-2017).

Backup procedure
  1. Start Microsoft SQL Server Management Studio on your TBS WE server computer.
  2. Right click Databases/TBS_BAWSE node and select Tasks -> Back Up… from the displayed context menu.
  3. Change destination file in Destination -> Back up to: section, if needed. Unless you are experienced IT administrator, keep default values of the other options untouched and click [OK] button.
  4. The backup file is created in the selected destination. Exit MS SQL Management Studio.

      
Restore procedure
  1. Start Microsoft SQL Server Management Studio on your TBS WE server computer.
  2. Right click Databases/TBS_BAWSE node and select Tasks -> Restore -> Database… from the displayed context menu.
  3. In Source to restore section, switch to From device option and click […] button.
  4. Click [Add] and browse for your stored backup file. Click [OK].
  5. In Select the backup sets to restore list, select (check the box in Restore column) the item you added in the previous step.
  6. To replace the existing database with the backup, select Options page in the Select a page list and check Overwrite the existing database (WITH REPLACE) option. Click [OK].
  7. Click [OK] to restore the data

     









    • Related Articles

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

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

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

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