DV1028 - Retrieve Archived Items from an Archive Database

The following describes how to restore individual items/records that have been archived. The steps described below are based upon creating a copy of the archived database, establishing it as the original database and then 'un-flagging' those items you wish to restore. This process is possible because archived items keep their "Flag for archive" boxes checked in the archived database.

The information in this article applies to:

• DOVICO Timesheet version 8.x

Instructions for DOVICO Timesheet version 9 can be found in KBase article DV1116.

Step 1 - Performing a Backup

This first step is a precautionary measure performed to create a copy of the current database.

1. Make sure that all users are logged off the software before continuing.
2. (Note: You may have to shut down MSDE or SQL Server 2000 service before you are able to copy the folder and make a back up.) Right click on the SQL Server engine in your system tray and Select MSSQLServer - Stop.
3. Make a backup of the Data folder. By default go to <Install-Dir>\Data make a copy and save it in a different location. (Note: If you are unable to copy the folder you have to shut down MSDE or SQL Server 2000 service before you are able to copy this folder.)
4. Start MSDE or SQL Server. Right click on the SQL Server icon in your system tray and select MSSQLServer - Start.

Step 2 - Ensuring the Archive database is up to date

The second step is to perform an Archive Database to ensure that the existing Archive database is up to date..

1. In order to perform an Archive Database. Open the Database Manager and login. Select the original database from the list. Select Maintenance, Archive Database.

When the Archive Database option is used, Database Manager will:

• Remove items in the selected database flagged as archived (see Flag for archive in Help).
• Store archived items to the archived database. If an employee is selected, it will also store timesheet entries.
• Copy all other information in the selected database to the archive.
• This enables you to see a perfect picture of the database at the date and time the Archive Database option was performed.
• You can archive a database as often as needed.

Step 3 – Replacing the original database

The following steps describe how to replace the original database with the updated archive database.

1. Open the Database Manager and login. Delete the original database by highlighting the database and selecting File, Delete Database.
2. Make a copy of the Archive database folder  (and contents) and place it in the same root directory as the archive database, by default <Install-Dir>\Data\.
3. Rename the folder to the original name of your database. (i.e. if your database name was demo, then rename the "Copy of DemoArchive" folder to "Demo")
4. Open the folder that was created in the previous step and rename the .mdf and .ldf files by right clicking on the file and choosing rename. Rename the files back to their original name by removing the word Archive.
5. Open the Database Manager and login. 
6. Select Maintenance, Restore Database from the menu. 
7. Enter the original database name in the Name box (example Demo).
8. Browse to the database folder (example: <Install-Dir>\Data\Demo) to find and select the .mdf file and click Open.
9. Browse to the database folder again (example: <Install-Dir>\Data\Demo) to find and select the .ldf file and click Open. The database will now be restored.

Step 4 – Retrieving archived items and restoring the data to its original state

1. Open DOVICO Timesheet and login to the database with the same user name and password that is used to logon to the original database.
2. Uncheck the Flag for Archive option for any items that you wish to retrieve.
   • You can uncheck the Flag For Archive option for any item in the following views: Employee, Client, Region, Team, Rates, Project Groups, Project, Task, Task Groups, Expense Categories, Overtime, Time and Attendance, Workflow, Security Groups.
3. Open the Database Manager and login. Delete the archive database by selecting File, Delete Database.
4. Archive the only database left which would be your original database.
5. Highlight the database and select Maintenance, Archive Database.