SQL Server Performance Forum – Threads Archive

SHRINKDATABASE fails

DBCC SHRINKDATABASE(‘test) On executing Shrink I get the follwoing error: 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. Does anyone know why? Thanks.

Check: http://support.microsoft.com/default.aspx?scid=kb;en-us;254253 Luis Martin
Moderator
SQL-Server-Performance.com 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
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>