O'Reilly logo
  • claudio r silveira thinks this is interesting:

Empty File (By Migrating the Data to Other Files in the Same Filegroup) Migrates the data contained in the data file to other files in the same filegroup. This is equivalent to using the DBCC SHRINKFILE with EMPTYFILE option. This operation prepares the file to be removed with an ALTER DATABASE statement.


Cover of Mastering SQL Server® 2008


Verificar a questão do Pergamo, que possui dois arquivos de data ou log.