hemul (2/21/2011)
Hi, thanks for your input. If this is the expected behavior of the shrink command, then the documentation is wrong or misleading:http://msdn.microsoft.com/en-us/library/ms190488(v=SQL.90).aspx
The database cannot be made smaller than the minimum size of the database. The minimum size is the size specified when the database is originally created, or the last size explicitly set by using a file size changing operation such as DBCC SHIRNKFILE or ALTER DATABASE.
So the question is whether there's something wrong the documentation or the command itself?
Well then, the documention is wrong - not the command.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs