Microsoft SQL
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…
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…
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…
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…
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…
Uninstalled Microsoft SQL Server but components have been left behind?
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…
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…
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…
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…