Restore

You can restore the Complete Time Tracking database from a previous backup in a data recovery situation or after server maintenance. Previous backup files are typically created with a .RBK filename extension.

Warning: Database user roles are stored within the database, therefore if you restore a database from a backup the roles for the users will be restored and set to those current at the time of the backup. After a restore you should review the roles in the database assigned to each database user to ensure that they are still appropriate.

1.	From within Complete Time Tracking Professional when you are currently logged in. Note: On Windows Vista and later computers restore must be performed using the Server Manager program due to the elevated privileges required.

2.	Using the Server Manager program if you are not currently logged in to Complete Time Tracking or the server is stopped.

Warning: The server will be briefly stopped to perform the restore. When the server is stopped, current users will experience connection errors when actively using Complete Time Tracking Professional and other users will not be able to log in. The active users will automatically be logged back in when the server is started and they begin to actively use Complete Time Tracking Professional. We therefore highly recommend that all users are logged off before the restore to avoid data loss. You can check the number of connected users from the Server Manager program.

1.	Select Start, All Programs (or Programs), Complete Time Tracking Professional Server, Server Manager. Alternatively on Windows Vista and later computers select Server Manager from the Tools menu in Complete Time Tracking.

3.	Browse to the location of the previously saved backup file.

4.	Select the backup file and click the Open button.

2.	Copy the appropriate folder(s) and contents from the backup to the Complete Time Tracking Professional databases folder.

Important: As stated previously the Complete Time Tracking Professional database server program must be stopped to back up the database. You must restore the folder(s) and their contents.

A third party backup product may be used to restore a database from a previous backup that it made. The important point is that the Complete Time Tracking Professional database server program must be stopped to restore the database. It is best to stop and start the database server program manually using the Server Manager before and after using the backup software to restore the database.