Restoring A Database

In order to restore and access a [email protected] or [email protected] database there are a number of steps which need to be undertaken depending on the version of the software under which the database has been backed up.

Note: This article is intended to assist our Partners Support Desks to restore [email protected] and [email protected] Databases.

For all versions of [email protected] and [email protected] (eXpense) prior to version 3.0 (i.e. 2.3, 2.4 and 2.5) it is not possible to restore a database under a different version of the software. The version under which the database is restored must exactly match the version from which the database was taken.

From Version 2.5 onwards it has been possible to restore a database into a later version of [email protected] or [email protected]

Irrespective of what version is being restored, if the Database is being restored from a different instance of SQL Server (for example it was backed up on a Clients SQL Server and Restored on a Support Desk SQL Server) then the following Script must be run against the database after it has been restored (in order to reset the SQL DB Owner):

sp_change_users_login ‘update_one’, ‘TWAdmin’, ‘TWAdmin’