October 29, 2009 at 1:46 pm
I am running SQL Server 2005 SP3 x64 Standard.
I have 5 data files and would like to only have 4. When I run the following command, I get the error below.
DBCC SHRINKFILE(FileName, EMPTYFILE)
“Cannot move all contents of file "FileName" to other places to complete the emptyfile operation”
Everywhere I have searched on this error, everyone says to install SP3. I have SP3 installed. I also have plenty of free space in the other files, and I have put the database in read only mode, stopped and started SQL Server, and even reboot. I still get the same error.
October 29, 2009 at 2:57 pm
- please provide the full statement exactly as you execute it !
(maybe even post the db create ddl)
- keep in mind, you cannot empty the primary file ! (it contains the inmovable catalog data.)
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply