I know this question has probably been asked a thousand times, so I apologise in advance, but I appear to be unable to reduce the physical file size of a log file I have on a database using the Full recovery model.
So far, I have done:
* Backed up the transaction log
* Perform full backup of the database
* Checked via DBCC OPENTRAN for open or active transaction - there are none
* DBCC SHRINKDATABASE
After using DBCC SHRINKDATABASE and even DBCC SHRINKFILE using the log file ID, I can see that using DBCC SQLPERF(LOGSPACE) that less than 1% of the 50Gb log file is in use.
Initially the log file was created with a 4Gb file size, so I expected that the file would return to this size after the usual steps, but this is not so.
I imagine I've missed something simple, so would be most grateful for any advice to get my log file back to its 4Gb original empty size.