INF: Disk Space Allocated for and Used by the Master Database

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