Problem with dbcc shrinkfile(datafile,targetsize)

Question

Viewing 5 posts - 16 through 19 (of 19 total)

You must be logged in to reply to this topic. Login to reply

Adiga One Orange Chip Points: 27284 More actions · Answer 1

DBAsql-1046554 (11/9/2010)
First query returns 1 row where as second does not return any.

This means there is an open transaction on Tempdb.

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga

DBAsql-1046554 Ten Centuries Points: 1088 More actions · Answer 2

Thank You so much for your help in this.

Unused space released back to the drive.

Adiga One Orange Chip Points: 27284 More actions · Answer 3

Glad to know that the issue is resolved.

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga

muthukkumaran Kaliyamoorthy SSCoach Points: 19026 More actions · Answer 4

DBAsql-1046554 (11/10/2010)
Thank You so much for your help in this.
Unused space released back to the drive.

How you did this?

DBAsql-1046554 Ten Centuries Points: 1088 More actions · Answer 5

Again run DBCC shrinkfile while no open transaction in tempdb worked out.