SOLIDWORKS PDM utilizes SQL as its database engine where one database file (.mdf) and at least one transaction log file (.ldf) is created. The database file stores the physical data added to the database, and the transaction log keeps records of database modifications. By default, the recovery method of a SQL database is set to ‘Full’. With Full recovery model set, a transaction log can grow until it is out of disk space which can make your Microsoft SQL Server database unusable. The following document will walk you through step by step on how to change your database recovery mode from ‘Full’ to ‘Simple’.
- This article's sole purpose is to supplement the SOLIDWORKS backup and restore procedures outlined in the SOLIDWORKS PDM Installation guide not replace.
- Using Simple Recovery, the database can be recovered to the point of the last full or differential backup. The database cannot be restored to the point of failure or to a specific point in time.
- With Full Recovery, the database can be recovered to the point of failure or to a specific point in time. If Full Recovery is used, then make sure the database files (MDF and LDF) are backed up on a regular schedule.
- If relying on daily full database backups, we recommend the recovery model is set to ‘Simple’ to limit the file size growth of the database transaction log (.LDF).
- The transaction logs are very important for maintaining the transactional integrity of the database. Do not delete the transaction log files, even after you make a backup of your database and the transaction logs.
1. Check the current Recover Model settings of your database:
- Log in to the SQL server as a system administrator.
- Start Microsoft SQL Server Management Studio.
- Login using a Local system administrator account or the ‘sa’ user account.
- Expand the ‘Databases’ folder.
- Right-click the database to check and select ‘Properties’.
- Under ‘Options’, view the ‘Recovery Model’ setting.