By Daniela Koloszko<\/em><\/p>\n\n\n\n In order to display the average value in an Excel report when you have multiple measurement inputs in SOLIDWORKS\u00ae Inspection, you can follow this procedure:<\/p>\n\n\n\n Refer to the image below for clarification.<\/p>\n\n\n\n By Tim Kwong<\/em><\/p>\n\n\n\n Far too often, users report their SQL server crashed and unable to restore from backup or no current backups are available. It is disheartening situation to inform users that it not possible to recreate a vault database from scratch or populate new information to an outdated backup. The inability to restore a PDM vault with a current backup of the database can result in loss of weeks and possibly months of work.<\/p>\n\n\n\n Performing regular backups of the vault database is the first and one of the key steps to allow the ability to recover from corruptions, crashes, and disasters. Backups do not guarantee a database can be restored and working properly. It is critical that a company implements a structured database backup routine and validation process. There is no quick method or process to determine if a backup can be restored and validate the integrity. A company must invest the necessary financial and human resources to test restore of backups and check the integrity of the restored database. Good backups are only when they can be restored and tested successfully.<\/p>\n\n\n\n The following outlines a backup and restore routine that a company should implement.<\/p>\n\n\n\n Monthly or quarterly testing of end of month backup in a test environment.<\/p>\n\n\n\n The two common remarks from users for not testing backups are the lack of knowledge and time to setup a test environment. Setting up a test environment and conducting periodic testing will require some effort and resources, but it is well worth the investment and effort. No company wants to be in situation where days, weeks, or months of work are lost due to corrupted backups. The following outlines the steps needed to restore a vault database and selective archive files for a test environment.<\/p>\n\n\n\n Restoring and Testing Vault Database Backup:<\/p>\n\n\n\n Why does SOLIDWORKS\u00ae 2021 Service Pack 5.0 stop functioning when modifying or creating a date custom property?<\/strong><\/p>\n\n\n\n This behavior may occur because of a fault in SOLIDWORKS\u00ae 2021 Service Pack (SP) 5.0 with pre-2018 custom properties. To get more information, see Solution ID:\u00a0S-079499<\/a><\/p>\n\n\n\n \u00a0When starting SOLIDWORKS\u00ae 2022 PR1, why do I see the error \u2018This limited life version of SOLIDWORKS has expired\u2019? Using the SOLIDWORKS\u00ae PDM software, what is the difference between removing a user from the \u2018Group Members\u2019 properties versus leaving the user and clearing the \u2018Member\u2019 check box?<\/strong><\/p>\n\n\n\n A user can be member of a group. You can also configure the user to have group membership, but only under a select folder. To get more information, see Solution ID:\u00a0S-079398<\/a><\/p>\n\n\n\n Where can I find an example of the use of an \u2018Action & reaction\u2019 force expression in a SOLIDWORKS\u00ae Motion study to represent a combination of spring and damper with complex behavior?<\/strong><\/p>\n\n\n\n The model in attachment of the solution ID:\u00a0S-079405<\/a>\u00a0contains a SOLIDWORKS\u00ae Motion study with such an example.<\/p>\n\n\n\n That\u2019s it for this month. Thanks for reading this edition of SOLIDWORKS Support News.<\/p>\n\n\n\n![\"\"](\"http:\/\/blogs.solidworks.com\/tech\/wp-content\/uploads\/sites\/4\/1-87.png\")
<\/a><\/figure>\n\n\n\nSOLIDWORKS PDM Vault Database Backup Routine<\/strong><\/h1>\n\n\n\n
Noteworthy Solutions from the SOLIDWORKS Knowledge Base<\/strong><\/h1>\n\n\n\n
<\/strong>The release of SOLIDWORKS 2022 SP0 will coincide with the release of 3DEXPERIENCE R2022x GA Customer Cloud later this month. To get more information, see Solution ID:\u00a0S-079513<\/a><\/p>\n\n\n\n
\n\n\n\n