DBCC SHRINKFILE on log file not reducing size even after BACKUP LOG TO DISK
Okay, here is a solution to reduce the physical size of the transaction file, but without changing the recovery mode to simple. Within your database, locate the file_id of the log file using the following query. SELECT * FROM sys.database_files; In my instance, the log file is file_id 2. Now we want to locate the … Read more