February 23, 2016 at 9:02 am
Dear
I need your support to solve this problem.
I have a BD which I am optimizing separating some of its FILEGROUP migrating to a new database.
The current BD FILEGROUP who migrated should be eliminated.
I have problems with one that is associated with a DATAFILE.
1. I deleted all objects (tables, indexes, PK, FK) residing in this DATAFILE.
2. I run: DBCC SHRINKFILE (DATAFILENAME, EMPTYFILE), but I get the following message:
DBCC SHRINKFILE: Page 3: 6349552 Could not Be Moved Because the partition to Which Belonged it was dropped.
Msg 2555, Level 16, State 1, Line 2
Can not move all contents of file "DATAFILENAME" to other places to complete the operation emptyfile.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
3. I have also tried to reduce the file because it has nothing associated, nor is reduced.
Terms:
1. Database SQL Server 2008 R2.
2. DATAFILE has 54GB size approx.
3. DATAFILE Initial Size is 48GB
Then I have two problems can not get reduce or completely cleaned to remove DATAFILE and therefore allow me to delete the FILEGROUP
February 24, 2016 at 4:06 am
please start by posting results of the following query
select 'Table [' + object_name(i.object_id) +
'] has index [' + i.name +
'] on partition scheme [' + ps.name + ']'
from sys.indexes i
inner join sys.partition_schemes ps
on i.data_space_id = ps.data_space_id
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 24, 2016 at 12:19 pm
Could not Be Moved Because the partition to Which Belonged it!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply