File vault backups should be part of the daily management of SOLIDWORKS Enterprise PDM (now SOLIDWORKS PDM Professional). They are also required before you upgrade your Enterprise PDM components.
When backing up the vault, the latest updates in files that are still checked out and modified on client workstations are not included since they are stored in the local file vault view or local cache of the client. To ensure that the latest information of all files is always included in a backup, the files should be checked in.
Back up the file vault database hosted on the SQL Server using professional backup software such as Veritas Backup Exec with SQL agent. You can also perform the backup using the SQL Management tools that are included with the SQL Server.
Use the SQL Maintenance Wizard to schedule a planned backup.
To create a database backup manually:
From the Start menu, click All Programs > Microsoft SQL Server 2008 SQL Server Management Studio.
In the Microsoft SQL Server Management Studio, expand the Database folder. For this example the ConisioMasterDb is being selected.
Right-click the database to be backed up, and select Tasks > Back Up.
In the Back Up databases dialog box, under Sources:
In the Select Backup Destination dialog box, enter a destination path and file name for the backed up database and click OK.
This location should be to a location that is not on the same location as your Enterprise PDM databases etc.
For each of the file vaults, repeat the backup database process. For this example, the following vault database backups would be created for adaptaero, evaluation, PDMWE_TerryTest, and Training.
The archive server contains file vault settings such as passwords and defined login types. It is also the physical location of the Enterprise PDM vault archive files. Backing up the archive server settings does not back up the archive files.
After backing up the archive server settings, include the backup file in your normal file backup.
On the archive server, from the Windows Start menu, click All Programs, SOLIDWORKS Enterprise, then select Archive Server Configuration.
Select Tools and then select Backup settings.
In the Backup Settings dialog box:
The backup file is saved in the specified location and called backup.dat.
Modify Your Quick Search Variable List in SOLIDWORKS PDM
SOLIDWORKS PDM Copying a Value from the Folder into a File’s Properties
How to Set Up Dynamically-controlled Card Lists in SOLIDWORKS PDM
SOLIDWORKS PDM and SQL Server Performance Considerations
About GoEngineer
GoEngineer delivers software, technology, and expertise that enable companies to unlock design innovation and deliver better products faster. With more than 40 years of experience and tens of thousands of customers in high tech, medical, machine design, energy and other industries, GoEngineer provides best-in-class design solutions from SOLIDWORKS CAD, Stratasys 3D printing, Creaform & Artec 3D scanning, CAMWorks, PLM, and more
Get our wide array of technical resources delivered right to your inbox.
Unsubscribe at any time.