_DBREINDEX and MDF file size

am running a _dbreindex database job in production that keeps failing
with the following error. Could not allocate space for object in
database '*' because the 'PRIMARY' filegroup is full..

size of drive 49.9G, (mdf file is the only thing on the drive)

size of datafile prior to running job 26.7 G,

I checked the size after the job failed and it was 41 G.

I have tried shrinking the database first to reduce the file size, and
then reindexing but nothing seems to work, I would like to use adding
additional space as a last resort. Is there a workaround or patch?

DBCC SHRINKDATABASE
( databasename, 10)
go

exec _dbreindex databasename
go

Any suggestions?




Email messages and attachments may contain confidential patient health
information that is legally protected. This information is intended only for
the use of the individual or entity named above. The authorized recipient of
this information is prohibited from disclosing this information to any other
party unless required to do so by law or regulation and is required to
destroy the information after its stated need has been fulfilled. If you are
not the intended recipient, you are hereby notified that any disclosure,
copying, distribution, or action taken in reliance on the contents of this
message is strictly prohibited. If you have received this message in error,
please notify the sender immediately by replying to this message and delete
the message from your system.

MySQL LazyDBA home page