SHRINKDATABASE fails | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive


DBCC SHRINKDATABASE(‘test)<br /><br />On executing Shrink I get the follwoing error:<br /><br />Executed as user: abcabcAdmin. Could not adjust the space allocation for file ‘test’. [SQLSTATE 42000] (Error 3140) DBCC execution completed. If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000] (Error 252<img src=’/community/emoticons/emotion-11.gif’ alt=’8)’ />. The step failed.<br /><br />Does anyone know why? <br />Thanks.
Check:;en-us;254253 Luis Martin
Moderator One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS” with no warranties for accuracy.
Thanks, But I am using SQL Server 2000 with SP3…
Check the free space on the disk where this file resides and ensure the database is enabled with AUTO_GROW in order to facilitate the DBCC statement execution. Also consider the specified workaround in KBA Some tables lend themselves to BCP or SELECT INTO operations, which allows the original table to be dropped or truncated. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.