Viewing 6 posts - 1 through 6 (of 6 total)
SOLUTION:
It turns out there is a bug in the SHRINKFILE Command - it has been fixed in SQL 2005 SP3 that is available for download. The SHRINKFILE with the EMPTYFILE...
March 5, 2009 at 2:14 am
Yes, there is enough space to accommodate the small bits of data remaining.
At this stage it is not allowing me at all to reduce the file size so I can't...
March 4, 2009 at 3:40 am
Hallo Ed,
OK, I executed a SHRINKFILE with EMPTYFILE switch again, got the same error with regards to being unable to move all data, namely
DBCC SHRINKFILE: Moving page 3:5866167 failed.
Msg...
March 3, 2009 at 10:11 pm
Hallo Ed,
I will go try this in the morning and give feedback. I am not worried about user impact, so I will try the SQL stop/start solution.
It is just strange...
March 3, 2009 at 4:53 am
No, the file I want to drop is the one added last - it is not the primary file that was created when the DB was created.
And yes, all 3...
March 2, 2009 at 1:55 pm
Hello Gail,
There are 2 additional files - the original file that is roughly 80GB in size, with about 55GB available, and a 2nd file that is 50GB in size...
March 2, 2009 at 1:10 pm
Viewing 6 posts - 1 through 6 (of 6 total)