Restore database backup

1. Open SQL Management Studio.

2. Right-click on the affected database in SQL Management Studio.

3. Select “Restore Database” (Restore => Database).

4. Select your backup under Device.

5. Also select the following options:

• Overwrite the existing database

• Close existing connections

6. Then confirm the restore process by clicking OK.

7. After restoring the database, you may need to adjust the SQL user. To do this, proceed as follows:

• Delete the SQL user in the database => expand etask_XXXX

• Expand Security.

• Expand Users and delete the SQL user (usually etask_XXXX, where XXXX stands for the customer code; please contact eTASK for this information).

8. Afterward, the existing SQL user must be reassigned from the SQL Server to the database. To do this, close the “Databases” menu item and open the “Security” menu => “Logins” => double-click etask_XXXX.

9. Under User Mapping, locate the corresponding database and set the following options:

After that, the FM Portal can use the restored database.