is that the value you entered in the field "shrink file to:" ?
That value has to be greater than the "minimum" file size and smaller than the "maximum" file size that has been set for the particular file.
Sanil Mhatre | Database Developer | MCTS | If you find my reply useful in any way, please vote it as helpful. If it has helped answer your question, please mark it as Answer. http://sqlwithsanil.com
Remember, this is not a good pratice:
If you wanna shrink anyway follow the article below:
André César Rodrigues
Please click the Mark as answer button and vote as helpful if this reply solves your problem. Thanks!Blog: http://sqlmagu.blogspot.com.br LinkedIn:
- Proposed as answer by Shanky_621Moderator Wednesday, August 07, 2013 5:09 AM
It is not always advisable to shrink data files as these files are usually growing. There are cases when one database can be separated in multiple databases. Shrinking database or data files can be long time process but it there are very small chances of data lose.
Following is the script to shrink whole database.
DBCC SHRINKDATABASE (dbName)
Following is the script to shrink single file.
DBCC SHRINKFILE (logicalLogFileName)