SQL

SOLIDWORKS PDM Standard & Professional Backup Process

SOLIDWORKS PDM Backup Process

SOLIDWORKS PDM provides a secure environment for users to store files, and safely keeps archived copies of these files on a central server, preventing most potential causes of data loss on local user’s computers. However, it is essential that copies of the PDM Archives and…

Read More...

SOLIDWORKS PDM Professional Replicate Database is new for 2017

Starting with the 2017 release of SOLIDWORKS PDM Professional, administrators can now take advantage of the “AlwaysOn Availability Groups” or AOAG in Microsoft SQL Enterprise edition.  This will allow for replication of the vault database to multiple locations. Previously, replication in PDM was available for Archives…

Read More...

SQL Tasks for improving SOLIDWORKS EPDM Vault Performance

While helping a customer to resolve SOLIDWORKS EPDM performance issues, I came across an SQL query in the SOLIDWORKS Knowledge Base, which can help determine if Rebuild, Reorder, or Shrink SQL maintenance tasks can be used to improve SOLIDWORKS EPDM Vault Performance. I found this utility…

Read More...

Backing Up PDM Databases Automatically with SQL Server Agent

Proper backups are an essential part of data management.  For SOLIDWORKS PDM, there are two key elements that must be backed up to ensure that data is safe, the vault archives, and the vault database. The vault archives are copies of the actual files stored…

Read More...

SOLIDWORKS Electrical IT Architecture

What constitutes a great installation, migration, or upgrade with SOLIDWORKS Electrical and the SOLIDWORKS Solutions? An informed audience of Users, IT Administrators, and Management, in conjunction with your friendly neighborhood SOLIDWORKS Product Gurus. Keeping all the experts in mind, I’ve shared my experience with the SOLIDWORKS Electrical IT…

Read More...