We always run into Transaction log problems all the time and as an SQL Server DBA and windows Architecture Engineer, I observed that shrinking Transaction log files to reclaim space is easy but can be ...
3 years+ experienced SQL Server DBA🧑💻 | Azure SQL | PostgreSQL | ETL | Performance Tuning | HA/DR | Backup & Recovery | T-SQL | Database Security | Production Support ...
declare @fltLogFilePercentageOfDataFile float = 0.25 -- set log file ratio - 0.2 = 20%, 0.25 = 25%, etc.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results