I have a SQL Server 2012 express addition with many databases that the log files have not been backed up in a long time. One log file is 1.1 TB. Anyway, after I backup the databases and log files. How do I skrink the log files? When I try I will get this message:
"Cannot shrink log file 2 (SS_NCShared_Vehicle_Log) because the logical log file located at the end of the file is in use."
Any advice would be welcome. I've been away from being a DBA for a long time. I've had these problems before but it was a long time ago and on a different version of SQL Server.