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.

SOLIDWORKS

If you rely on daily full-database backups, define the recovery model as Simple instead. The Simple recovery model limits the growth of the database-transaction log. 

To determine the recovery model of a database, follow these steps: 

5. In SQL Server Management Studio, expand the Databases folder. 

6. Right-click the database and select Properties. 

7. Under Options, view the Recovery Model setting.

SOLIDWORKS

After defining the recovery model as Simple for a database, you can shrink the current transaction log file to regain space:

1. In SQL Server Management Studio, expand the Databases folder. 

2. Right-click the database that has the transaction log you want to shrink and select Tasks > Shrink > Files. 

3. For the File Type, select Log. The dialog box displays the amount of free space available. Note: Do not shrink the actual database file. 

4. Click OK to shrink the log file.

SOLIDWORKS

If the recovery model is Simple, you now regain the free space. If the recovery model is Full, you must likely first back up the transaction log file before you can shrink the file.

Contact Us: Have questions or need assistance? Feel free to reach out!

Phone: +91 94454 24704
Email: mktg@egs.co.in


Comments

Post a Comment

Popular posts from this blog

SOLIDWOKRS TECH TIP - SOLIDWORKS PROPERTY TAB BUILDER

-
Image
The Property Tab Builder is a stand-alone utility that you use to create a customized interface for entering properties into SOLIDWORKS files. Traditionally, designer's use to modify the drawing template to insert custom property such as Description, Part No, Material, it’s a manual method. so, designers have to modify the custom property or metadata on each time, simultaneously BOM creation is also manual which increases a run time and errors in BOM table. It's also delayed the release of entire project. Three ways to create a customized interface for property template. In the SOLIDWORKS software, on the Custom Properties tab in the Task Pane, click Create now. In the SOLIDWORKS software, on the SOLIDWORKS Resources tab of the Task Pane, click Property Tab Builder From the Windows Start menu, click All Programs > SOLIDWORKS version > SOLIDWORKS Tools > Property Tab Builder version. To create the property tab, you will need to first create a new fil...
Read more

Confused With Wire/Cable Harnessing? - Harnessing Technology By SolidWorks Electrical

-
Image
SolidWorks Electrical is an intuitive and powerful tool which takes care of wire and cable harness design and create the flattened view with automatic updated BOM/Cut. Engineers need to put more thought into thinks like wire length, bending radius and routing. As wiring harness become increasingly complex and an important part of design we are in need of a powerful tool to ease our design process, this is where SolidWorks Electrical comes into play. Today in Automotive sector there are many more computers and Electronic Control Units used in vehicles today. These ECU are used to control the transmission, and other major devices of the vehicle and they have to be connected via wire harness in order for the system to work What is Wire Harness? The wire harness is compactly bundled wire which plays as the conduit for transmission of control and power signals acting as the “Central Nervous System of a vehicle”. When designing a new product, engineers focus mainly on f...
Read more

SolidWorks Electrical Solutions for Control Panel Design

-
Image
Control panel Control Panel is a cabinet made up of sheet metal form, which enhouses lot of electrical and electronic components. Ultimately, designed and built to meet the customer Automation needs. Challenges Faced in Control Panel Design: Optimizing the Routing of Wires to save Cost Need for Intelligence in Sheetmetal handling to make immediate changes Respond to Customer Requirements or Design Change and update the Project Interference and Clearance Check between Wiring and Electrical Components  Accurate generation of BOM/BOQ (Bill of Materials/Quantity)  Control Diagram & Power Diagram creation Reducing Manual errors and Mismatch of Electrical Components. Solidworks Workflow for Control Panel Design: Control Panel Design starts with the creation of SLD (Single Line Diagram), followed by the detailed Schematic diagram.             Schematic Diagram...
Read more