How to delete the MSSQL transaction log.
If your transaction log is big or too much large. it will utilize your space and other issue might be there, so you need to clean up the transaction log time to time. Follow the following steps and clean your LOG size.
1) first take log backup
BACKUP LOG IMEKL TO [...]
Filed under: How to delete the MSSQL transaction log. | Tagged: Advance query, BACKUP LOG, Database tricks, DBA jobs, DBCC, DBCC SHRINKFILE, How to check file size from query, How to delete the MSSQL transaction log., MSSQL LOG BACKUP, step to clean your LOG size, Tips, tricks | Leave a Comment »
