We are using SQL Server 2008 with full recovery model, the database size is 10 GB and the log file is 172 GB, we want to clear up the space of the log file internally, we did transaction log file backup it should be clear up , but it still 172 GB. What to do?
you can create a new log file for the database on a different disk that has enough space by using the ALTER DATABASE YourDatabaseName ADD LOG FILE syntax.
Discuss This Question: 1  Reply