Microsoft SQL

Sizing the Microsoft SQL Primary Data (mdf) and Transaction Log (ldf) files

A Microsoft SQL database consists a primary data file (mdf) a secondary data file (ndf) and a transaction log file (ldf). For this article, we will concern ourselves with the mdf and ldf files. MDF stands for Main Database File and contains all the information…

Read More...

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...

How to Avoid Locking Out the Microsoft SQL sa Account

Starting with Microsoft SQL 2005, the Password Policy and Password Lockout settings from the Windows Operating System (found by going to Control Panel > Administrative Tools > Local Security Policy > Account Policies) are automatically inherited by the sa account in SQL. This could lead…

Read More...

Removing Old SQL Database Backups

To ensure the safety of your SOLIDWORKS PDM data, it’s essential to have a maintenance plan in place to perform regular (preferably nightly) backups of the vault database and the ConisioMasterDB database.  A Maintenance Plan that will automatically backup the databases can be set up…

Read More...

Uninstalled Microsoft SQL Server but components have been left behind?

Uninstall microsoft sql server

In some cases, when you uninstall Microsoft SQL Server, some components may be left behind. This could prevent the proper re-installation of Microsoft SQL Server, or interfere with its normal operation. As an example, a SOLIDWORKS PDM Administrator may encounter connection issues, when attempting to…

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...

New SOLIDWORKS PDM Professional 2017 Licenses

With the release of SOLIDWORKS PDM Professional 2017, Dassault Systèmes has introduced two new license models. SOLIDWORKS PDM Professional Add-on Licenses The first of these, is SOLIDWORKS PDM Professional Add-on Licenses. This license type is ideal for companies who already have Microsoft SQL Server, including…

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...