Skip to main content
Version: v3

SqlFileSpec Element (Sql Extension)

Description
File specification for a Sql database.
Windows Installer references
None
Parents
SqlDatabase
Inner Text
None
Children
None
Attributes
NameTypeDescriptionRequired
IdStringID of the file specification.Yes
FilenameStringSpecifies the operating-system file name for the database file.Yes
GrowthSizeString Specifies the growth increment of the database file. The GB, MB and KB and % suffixes can be used to specify gigabytes, megabytes, kilobytes or a percentage of the current file size to grow. The default is megabytes if no suffix is specified. The default value is 10% if GrowthSize is not specified, and the minimum value is 64 KB. The GrowthSize setting for a file cannot exceed the MaxSize setting.  
MaxSizeString Specifies the maximum size to which the database file can grow. The GB, MB and KB suffixes can be used to to specify gigabytes, megabytes or kilobytes. The default is megabytes if no suffix is specified. If MaxSize is not specified, the file will grow until the disk is full.  
NameStringSpecifies the logical name for the database file. 
SizeString Specifies the size of the database file. The GB, MB and KB suffixes can be used to specify gigabytes, megabytes or kilobytes. The default is megabytes if no suffix is specified. When a Size is not supplied for a database file, SQL Server uses the size of the primary file in the model database.  
See Also
Sql Schema