Thanks, I know I shouldn't be shrinking my database. I'm just trying to figure out how shrinking works and how it relates to the initial/default file size.
I argue that DBCC SHRINKFILE is not working as expected. Let me quote Microsoft again:
DBCC SHRINKFILE, target_size: Is the size for the file in megabytes, expressed as an integer. If not specified, DBCC SHRINKFILE reduces the size to the default file size. The default size is the size specified when the file was created, or the last size set by using ALTER DATABASE.
http://technet.microsoft.com/en-us/library/ms189493%28SQL.90%29.aspx
First I execute ALTER DATABASE to change the default size to 4096 megabytes.
Then I execute DBCC SHRINKFILE without specifying target_size.
DBCC SHRINKFILE ignores the "last size set by using ALTER DATABASE" and shrinks to 1024 megabytes.
For me this raises a couple of questions:
-How do you change the "initial size" of a database after you created it?
-When you execute ALTER DATABASE and specifies a new SIZE, does that change the "initial size"?
-Documentation refers to "default size", is that the same as the "initial size"?
Thanks.