SQL Server Performance Forum – Threads Archive

Shrinkfile Error

Any body got any ideas how we might get around the following error. command used: dbcc shrinkfile(‘DB_Data’,EMPTYFILE)
Result: DBCC SHRINKFILE: Page 3:9224674 could not be moved because the partition to which it belonged was dropped. Msg 2555, Level 16, State 2, Line 1 Cannot move all contents of file "DB_Data" to other places to complete the emptyfile operation. DBCC execution completed. If DBCC printed error messages, contact your system administrator.
The file needs to be split from 1 x 200G file into multiple data files. Works for a couple of hours the gives this error, file is still 100G, but has 99% empty space. Cheers
There are 10 types of people, those who understand binary jokes and those who dont

Is there any partitioned object exists in on this file which spans to different file group? EMPTYFILE option migrates all data from the specified file to other files in the same filegroup. If you have partitioned object then move that object to diffent file group and then try again… MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

Also confirm the output of
select * from sysfiles
in addition to SP_SPACUSED on this particular table or database.
By chance doyou have any IMAGE or TEXT type data type on this database? Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

]]>