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