October 11, 2017 at 11:39 am
For months we have been running a background process to spread data from a 5 TB .mdf file across 15 smaller .ndf files. Opportunistically during downtimes, we have been shrinking the original .mdf as much as possible with the intention of getting the size to ultimately match that of the .ndf files
Our most recent shrink attempt, ie
USE [BigMama]
GO
DBCC SHRINKFILE (N' BigMama_data' , 400000)
GO
Threw this error-
Removing IAM page (17:33394451) failed because someone else is using the object that this IAM page belongs to.
A quick google search finds some similar error messages (Multiple IAM pages for object) and references to error #1119 but no solids leads or anything very current. We are running a DBCC CheckDB, but if anyone has experience with this I’d appreciate your input.
(FWIW- This is a multi-tenant db and we are moving to a smaller single-tenant model next year)
October 13, 2017 at 12:29 pm
Just an update... CHECKDB found 0 allocation errors and 0 consistency errors in database and we are unable to reproduce the error on a copy of the db. I guess we'll just try again next downtime.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply