/* Create database, with default size of 4096 megabytes. */
CREATE DATABASE Testdb ON PRIMARY 
(NAME = N'Testdb_data', FILENAME = N'C:\Program files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\Testdb_data.mdf' , SIZE = 4096MB, FILEGROWTH = 0)
LOG ON 
(NAME = N'Testdb_log', FILENAME = N'C:\Program files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\Testdb_log.ldf' , SIZE = 1024KB, FILEGROWTH = 10%)
GO

/* Use the new database */
USE Testdb
GO

/* Shrink the data file, no size specified = use default file size.
Size won't go below 4096 megabytes, Windows Explorer confirms this.
Repeatedly executing this command doesn't change the data file size.
This is expected behavior. */
DBCC SHRINKFILE (N'Testdb_data')
GO

/* Shrink the data file to 1024 megabytes.
Size does indeed change to 1024 megabytes, Windows Explorer confirms this.
This is expected behavior. */
DBCC SHRINKFILE (N'Testdb_data', 1024)
GO

/* Alter database, change default data file size to 4096 megabytes again.
Data file grows from 1024 to 4096 megabytes, Windows Explorer confirms this.
This is expected behavior. */
ALTER DATABASE Testdb MODIFY FILE (NAME = N'Testdb_data', SIZE = 4096MB, FILEGROWTH = 0)
GO

/* Shrink the data file, no size specified = use default file size. (ie. 4096 megabytes)
Data file shrinks to 1024 megabytes again, Windows Explorer confirms this.
Why??? This is confusing to me. I explicitly set the default size to 4096 megabytes using ALTER DATABASE below.
Expected behavior: data file should not shrink below default size of 4096 megabytes. */
DBCC SHRINKFILE (N'Testdb_data')
GO

/* Create Testdb1 with initial size = 4096MB */
CREATE DATABASE Testdb1 ON PRIMARY
(NAME = N'Testdb1_data', FILENAME = N'C:\Program files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\Testdb1_data.mdf', SIZE = 4096MB, FILEGROWTH=1024KB)
LOG ON
(NAME = N'Testdb1_log', FILENAME = N'C:\Program files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\Testdb1_log.ldf', SIZE = 1024KB , FILEGROWTH=10%)
GO

/* Create Testdb2 with initial size = 3MB */
CREATE DATABASE Testdb2 ON PRIMARY
(NAME = N'Testdb2_data', FILENAME = N'C:\Program files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\Testdb2_data.mdf', SIZE = 3MB, FILEGROWTH=1024KB)
LOG ON
(NAME = N'Testdb2_log', FILENAME = N'C:\Program files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\Testdb2_log.ldf', SIZE = 1024KB , FILEGROWTH=10%)
GO

/* Increase initial size of Testdb2 to 4096MB */
ALTER DATABASE Testdb2 MODIFY FILE (NAME = N'Testdb2_data', SIZE = 4096MB)
GO

/*
Shrink both databases. Here is the result: 
Testdb1_data.mdf = 4096MB
Testdb2_data.mdf = 3MB (expected result: 4096MB)
*/
DBCC SHRINKDATABASE('Testdb1')
DBCC SHRINKDATABASE('Testdb2')
GO