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