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.