Restoring an Incorrectly Upgraded Version from a Backup

If an upgraded version of a file is incorrect, you can use the backup file to restore the original content of the file.

1. In the local file vault view, determine the name of the file to find.
2. Open Microsoft SQL Server Management Studio and click Connect.
3. Expand Databases and select the vault containing the file you want to restore.
4. Click New Query.
5. In the right pane, type a query in the following format:

   select * from documents
   where filename like 'filename.ext'

   For example:

   select * from documents
   where filename like 'speaker_frame.sldprt'

6. Click Execute.

   Record the files DocumentID, which is listed in the Results tab.

7. Exit the SQl Server Management Studio.
8. Use a calculator to convert the DocumentID to hexadecimal format.
9. In an Explorer window, navigate to install_dir\Program Files\SOLIDWORKS Enterprise PDM\Data\vault_name.
10. Expand the vault archive that matches the last digit of the hexadecimal number.

    For example, if the hexadecimal number is 3B, expand the folder labeled B.

11. Expand the folder that matches the hexadecimal number.
12. Rename or delete the version of the file you want to restore.

    For example, rename 00000002.sldprt to 00000002.backup.

13. Rename the appropriate bak_ file to the original file name.

    For example, rename bak_0_00000002.sldprt to 00000002.sldprt.

14. Exit Microsoft SQL Server Management Studio.