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.
- Chapter 3: Databases, Files, and Resource Management
- from Mastering SQL Server® 2008
- Publisher: Sybex
- Released: January 2009
Verificar a questão do Pergamo, que possui dois arquivos de data ou log.
Share this highlighthttp://www.safaribooksonline.com/a/mastering-sql-server/4306/