ID Number: Q64610
1.10 1.11 4.20
OS/2
Summary:
When SQL Server is installed, the user is asked to specify the amount
of disk space to be allocated for master device. This value is
different from what shows up when an "sp_spaceused master" is executed
after installation.
More Information:
When you instruct the SQL Server installation program to create a
16-megabyte (MB) master database, this value (in this case, 16 MB) is
actually used in the DISK INIT command to indicate the amount of disk
space that should be allocated to the master database logical device
where the master database file (MASTER.DAT) resides. The size of any
device can be found by executing the stored procedure sp_helpdevice.
3 MB is the default value for the size of the master database file
used by the installation program when executing the CREATE DATABASE
command. Thus, 3 MB is the amount of space used on the master database
device and is the size of the master database file.
Additional reference words: 1.10 1.11 4.20 Segments