FROM sys.database_files WHERE type_desc = ‘LOG’ Once I have my log file name, I can use the DBCC command to shrink the file. In the following command I try to shrink my log file down to 1GB.

read file mysql-slow.log and find out all sql records; group the sqls with their normalized format, for simple, use md5 for each as unique key; compute average time for each normailized sql format ...

SQL File Splitter A Python script to split a large SQL file into smaller, manageable chunks. This can be particularly useful when dealing with enormous SQL dumps that need to be imported in parts or ...

The tool analyses the SQL transactions log i.e. LDF file to detect any vital changes in the database records. The software is best for Forensic investigation and tracking all the transaction history ...

2. Use the SQL Server Management Studio (SSMS) First, we will restore the BAK file in SSMS; for that, follow these steps: Press the Windows key, type sql server management studio, and click Open to ...