vendredi 6 mai 2011

SQL Server : Shrink failed for Database ‘Data base name’.

You try to shrink a database and you get the following error

TITLE: Microsoft SQL Server Management Studio
Shrink failed for Database ‘Data base name’. (Microsoft.SqlServer.Smo)
For help, click:
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. (Microsoft SQL Server, Error: 0)
For help, click:

The problem is that there is not enough disk space to shrink your database.

Free up disk space on the partition where the database is and that should work !

Aucun commentaire:

Enregistrer un commentaire