SHRINKFILE FAILED

[icemel]

Hi,

Last night ran:
DBCC SHRINKFILE (myFile)

Got this error msg:
Could not adjust the space allocation for file 'myFile'

Any clues as to why this failed??

Thanks

 

[mrdenny]

Was there any more info in the output? (Post it all, it's the innocent looking parts that matter the most.)

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[icemel]

Coincidentally enough, I found the answer in my 70-228 uCertify prep test this morning! They had a question about this exact error message - the answer is that the shrink was conflicting with a diff backup.

 

[mrdenny]

ah, hah. That would do it.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com