Friday, August 14, 2015

Remove Multiple Log Files

For a table compression project we added an additional log to the database to handle the increased utilization.  Now we need to drop that log.

--Drop the log
ALTER DATABASE ED1 REMOVE FILE ED1LOG2

But I still see the extra log file in database properties.  What is going on?  The file does not exist in

select * from sys.sysfiles

To fix the display of the extra log file that has been removed:

 Run the log backup for the database.

This removes the extra log from database properties and we are back to normal operations.

No comments:

Post a Comment