Microsoft SQL

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 for SOLIDWORKS PDM Professional using the SQL Server Agent included…

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 access the SQL Server. After running a ODBC (Open Database Connectivity)…

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 is included with the SOLIDWORKS installation media.  Here are two…

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 installations of those that were bundled with SOLIDWORKS PDM Professional…

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 only.  This functionality allowed the actual files themselves to be…

Read More...

Checking for Index Fragmentation in SOLIDWORKS EPDM

This article was originally intended to introduce the Reorder and Reorganize tasks in SQL. These tasks will be discussed in other articles, but while researching for this article my mindset on the aforementioned tasks, has shifted somewhat. First let’s look at how to check for fragmentation. Check Fragmentation Query If you do a little research you will…

Read More...

SOLIDWORKS EPDM SQL Maintenance Task Shrink Database

The Shrink Database task reduces the size of SQL Server database data and log files. This task can cause index fragmentation and is not recommended by SOLIDWORKS. SOLIDWORKS does note that “on large databases or environments with hundreds of users, shrinking the SOLIDWORKS® Enterprise PDM database once per year may improve overall performance.” Please refer…

Read More...

SOLIDWORKS Electrical Cannot Connect to Database?!

One of the most commonly seen errors when trying to launch SOLIDWORKS Electrical is the “cannot connect to database” error.  If you have ever run into the error message below, this article will give a how-to guide for quickly and easily resolving the issue. This error message may occur for a few reasons, however it most often…

Read More...

Want to become a SOLIDWORKS Expert?

Take a LIVE Online Training Course from Javelin