If an upgraded version of a file is incorrect, you can use the backup file to restore the original content of the file.
- In the local file vault view, determine the name of the file to find.
- Open Microsoft SQL Server Management Studio and click Connect.
- Expand Databases and select the vault containing the file you want to restore.
- Click New Query.
- 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'
- Click Execute.
Record the files DocumentID, which is listed in the Results tab.
- Exit the SQl Server Management Studio.
- Use a calculator to convert the DocumentID to hexadecimal format.
- In an Explorer window, navigate to install_dir\Program Files\SOLIDWORKS PDM\Data\vault_name.
- 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.
- Expand the folder that matches the hexadecimal number.
- Rename or delete the version of the file you want to restore.
For example, rename 00000002.sldprt to 00000002.backup.
- Rename the appropriate bak_ file to the original file name.
For example, rename bak_0_00000002.sldprt to 00000002.sldprt.
- Exit Microsoft SQL Server Management Studio.