The KB, MB, GB, and TB suffixes can be used to specify kilobytes, megabytes, gigabytes, or terabytes. Specify a whole number and do not include a decimal.
To specify a fraction of a megabyte, convert the value to kilobytes by multiplying the number by 1024.
For example, specify 1536 KB instead of 1.5 MB (1.5 x 1024 = 1536).
MAXSIZE Specifies the maximum file size to which the file can grow. The KB, MB, GB, and TB suffixes can be used to specify kilobytes, megabytes, gigabytes, or terabytes. Specify a whole number and do not include a decimal.
The SIZE and FILEGROWTH properties do not apply to a FILESTREAM filegroup.
' ' For a memory-optimized filegroup, FILENAME refers to a path where memory-optimized data will be stored.
The value can be specified in MB, KB, GB, TB, or percent (%).
If a number is specified without an MB, KB, or % suffix, the default is MB.For example, if you specify the path C:\My Files\My Data, C:\My Files must exist before you run ALTER DATABASE, but the My Data folder must not exist.The filegroup and file ( is not specified for the file, the Database Engine makes the file 1 MB.The file must reside on the server on which SQL Server is installed.The specified path must exist before executing the ALTER DATABASE statement.REMOVE FILE Warning Removing a database file that has FILE_SNAPSHOT backups associated with it will succeed, but any associated snapshots will not be deleted to avoid invalidating the backups referring to the database file.