My SQL Server Log File is too big ... has enough space by using the ALTER DATABASE YourDatabaseName ADD LOG FILE syntax. Shrinking the File Once you have identified your problem and have ...

Run full backup of SQL databases. Keep the backups! Then in the SQL Management Studio shrink the log file sizes. They won't shrink by themselves. From then on, run regular SQL backups and the logs ...