sys.databases | . |
sys.filegroups | . |
sys.database_files | . |
SQL Server Management Studio
11
SQL Server 32 767 . 2 ( ) . 32 767 32 767 .
model. , , , , , , model, . , .
CREATE DATABASE:
CREATE DATABASE database_name
[ ON
{ [ PRIMARY ] [ <filespec> [,...n ]
[, <filegroup> [,...n ] ]
[ LOG ON { <filespec> [,...n ] } ] }
]
[ COLLATE collation_name ]
]
<filespec>::=
{
(
NAME = logical_file_name,
FILENAME = { 'os_file_name' }
[, SIZE = size [ KB | MB | GB | TB ] ]
[, MAXSIZE = { max_size [ KB | MB | GB | TB ] | UNLIMITED } ]
[, FILEGROWTH = growth_increment [ KB | MB | GB | TB | % ] ]
) [,...n ]
}
<filegroup>::=
{
FILEGROUP filegroup_name [ CONTAINS FILESTREAM ] [ DEFAULT ]
<filespec> [,...n ]
}
Database_name
. SQL Server .
database_name 128 , . , SQL Server logical_file_name os_file_name database_name. database_name 123 , 128 .
, SQL Server database_name logical_file_name os_file_name. . ( ) Management Studio. SQL Server.
ON
, , , . ON , <filespec> -, . <filegroup> -, .
|
|
PRIMARY
, <filespec> . , <filespec> , . .
PRIMARY , CREATE DATABASE .
LOG ON
, , , , . LOG ON <filespec> -, . LOG ON , , : 512 25 . .
<filespec>
.
NAME logical_file_name
, SQL Server . logical_file_name . , .
FILENAME { 'os_file_name' }
- , . : , SQL Server, SAN iSCSI. CREATE DATABASE.
FILESTREAM FILENAME , FILESTREAM. , . , "D:\DATA\ FilestreamData ", " D:\DATA" CREATE DATABASE, "FilestreamData" - .
FILESTREAM , .
SIZE, MAXSIZE FILEGROWTH FILESTREAM , UNC.
(raw partition), os_file_name . .
, , . .
SIZE size
. SIZE , os_file_name UNC.
size , Database Engine , model. , size , Database Engine 1 . , , model.
|
|
(KB), (MB), (GB) (TB). M. Size integer. , 2 147 483 647, .
MAXSIZE max_size
, . MAXSIZE , os_file_name UNC. KB, MB, GB TB. M. ( ). max_size , . Max_size integer. , 2 147 483 647, . UNLIMITED , . SQL Server , , 2 , 16 .