DBCC SHRINKFILE

Question

Post reply

DBCC SHRINKFILE

danial_i

Mr or Mrs. 500

Points: 508
More actions
May 17, 2006 at 1:57 pm

#168304

I restored a SQL-2000 DB on a SQL-2005, I tried to shrink the database files through Management Studio, I got the following error messages:

TITLE: Microsoft SQL Server Management Studio
------------------------------

Shrink failed for DataFile 'SSCT_DATA-P1'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Shrink+DataFile&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------

A severe error occurred on the current command. The results, if any, should be discarded.
DBCC SHRINKFILE: File ID 1 of database ID 12 was skipped because the file size was changed in the middle of shrink operation. (Microsoft SQL Server, Error: 0)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.2047&EvtSrc=MSSQLServer&EvtID=0&LinkId=20476

------------------------------
BUTTONS:
OK
------------------------------

Then, I ran DBCC CHECKALLC and DBCC CHECKDB, no error reported. If I tried the shrink_file processes to shrink a small amount of space, it works fine.
I checked the space on disk drives, and I do have plenty of space available for the TRANSACTION_LOG growths.

Any help would be appreciated.

D. Danial

Viewing 2 posts - 1 through 1 (of 1 total)

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

Amit Lohia SSCertifiable Points: 6104 More actions · Answer 1

looks like there is high activity is going on that database. Try running this when no users are connected.

Kindest Regards,

Amit Lohia