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.
