We have a large database 200GB+ to which we added a second log file to cater for growth during an upgrade. This is now no longer needed so we want to remove it. Normally this would be a simple ALTER DATABASE <blah> REMOVE FILE <filename> statement.
However our database is log shipped to a secondary for reporting, so the question is – will removing this file break log shipping?
Server is SQL Server 2005 SP3 Standard Edition if it has any bearing.
Best Answer
Removing the extra file won't give you any problems.