How to Prevent and Shrink Large SQL Transaction Logs in SOLIDWORKS PDM?
Prevent and Shrink Large SQL Transaction Logs in SOLIDWORKS PDM In Microsoft® SQL Server®, all newly created databases define the recovery model as Full. Perform regular backups of the transaction log to prevent it from growing too large for the database size. If the transaction log grows until you run out of disk space, SQL Server becomes unable to perform any data-modification operations to the vault database. The transaction-log file usually exists in a folder next to the masterdatabase file (MDF) and has the LDF file extension. For example, Engineering_log.LDF. To find the location of the MDF and LDF files for a database: Go to Start > All Programs > Microsoft SQL Server > SQL Server Management Studio. 1. Log in to the SQL Server as a system administrator. 2. Expand the Databases folder. 3. Right-click the database and select Properties. 4. Under Files, view the location of the database files. If you rely on daily full-databas...