• I stand corrected and have removed the inaccurate post. Is it possible that technique worked in SQL 2000? I've confirmed exactly what you stated using a copy of the AdventureWorks2008R2 database and the EMPTYFILE clause has no effect on the transactions that exist in the 3rd file. I've confirmed it both with DBCC LOGINFO.