I have just inherited a database with a log file size of 3.5GB, but the actual data used in the log file is only about 70MB. I have tried the DBCC SHRINKFILE command, but the log file still will not shrink even after numerous log backups and database backups. Can someone help me here? What am I missing?
Jason