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.

In this solution, SQL Server Failover Cluster Instances (FCI) are installed across Windows Server Failover Clustering (WSFC) nodes. The included terraform module provisions up to two Amazon EC2 SQL ...