SQL Management Studio

How to shrink the SOLIDWORKS PDM SQL Transaction Log

SOLIDWORKS PDM Transaction Log

Within Microsoft SQL, every SOLIDWORKS PDM vault database has a transaction log associated with it that records the modifications to the database.  In some scenarios, if this log grows large it can cause performance issues within SQL and the vault.  If you’ve recently changed the…

Read More...

How to change the SOLIDWORKS PDM Database Recovery Model

With SOLIDWORKS PDM Professional, SOLIDWORKS PDM Standard, and SQL Management Studio by default within Microsoft SQL, the recovery model option for any new databases is set to full.  In some instances this can cause problems later as the full recovery model; causes the transaction log to grow…

Read More...

Installing SQL Server Express and the Management Studio

SQL Server Express

The SQL Server Management Studio (SSMS) is an integral component for administrating SOLIDWORKS PDM, as it allows us to maintain and capture backups of the database.  When installing a new instance of SQL Express for PDM Standard via the installation manager, the management studio is…

Read More...

Installing the SQL Server Management Studio (SSMS)

The SQL Server Management Studio (SSMS) is an integral component for administrating SOLIDWORKS PDM, as it allows us to maintain and capture backups of the database.  When installing a new instance of SQL Express via the installation manager for SOLIDWORKS PDM 2019 and later versions,…

Read More...

Installing SQL Management Studio for SOLIDWORKS PDM Standard

The backbone of the SOLIDWORKS PDM Standard vault is the database in Microsoft SQL Server Express.The SQL Express server databases can be managed and maintained using the SQL Management Studio.  This program is not installed automatically when installing SOLIDWORKS PDM Standard server components, however it…

Read More...