鏈�鏂扮簿鍝佹枃妗ｏ紝鐭ヨ瘑鍏变韩锛?/p>
锛?/p>
鏁版嵁搴撳師鐞嗗強搴旂敤瀹為獙鎶ュ憡
瀛﹀彿锛?/p>
濮撳悕锛?/p>
瀹為獙
1
涓�銆佸疄楠岀洰鐨勶細
鐔熸倝
SQL Server
浣跨敤鐣岄潰锛屾帉鎻′娇鐢?/p>
SSMS
鍜?/p>
SQL
璇彞鍒涘缓骞惰缃暟鎹簱銆?/p>
浜屻�佸疄楠屽師鐞嗭細
1.
浣跨敤
SSMS
鍒涘缓鏁版嵁搴?/p>
2.
鍒涘缓鏁版嵁搴撹鍙ワ細
CREATE DATABASE
鏁版嵁搴撳悕
[ON [PRIMARY] //
鎸囧畾涓�涓枃浠朵负涓昏鏂囦欢
[<
鏂囦欢鏍煎紡
>[
锛屸�?/p>
n]]
[
锛?/p>
<
鏂囦欢缁勬牸寮?/p>
>[
锛屸�?/p>
n]] ]
[LOG ON {<
鏂囦欢鏍煎紡
>[
锛屸�?/p>
n]}]
<
鏂囦欢鏍煎紡
>::=
([NAME=
閫昏緫鏂囦欢鍚?/p>
,]
FILENAME=
鈥樻搷浣滅郴缁熶笅鐨勬枃浠跺悕鍜岃矾寰勨�?/p>
[
锛?/p>
SIZE=
鏂囦欢鍒濆瀹归噺
]
[
锛?/p>
MAXSIZE={
鏂囦欢鏈�澶у閲?/p>
|UNLIMITED}]
[
锛?/p>
FILEGROWTH=
閫掑鍊?/p>
])[
锛屸�?/p>
n]
<
鏂囦欢缁勬牸寮?/p>
>::=FILEGROUP
鏂囦欢缁勫悕
<
鏂囦欢鏍煎紡
>[
锛屸�?/p>
n]
3.
淇敼鏁版嵁搴撹鍙ワ細
ALTER DATABASE
鏁版嵁搴撳悕
{ADD FILE <
鏂囦欢鏍煎紡
>[,
鈥?/p>
n] [TO FILEGROUP
鏂囦欢缁勫悕
]
|ADD LOG FILE<
鏂囦欢鏍煎紡
>[
锛屸�?/p>
n]
|REMOVE FILE
閫昏緫鏂囦欢鍚?/p>
|ADD FILEGROUP
鏂囦欢缁勫悕
|REMOVE FILEGROUP
鏂囦欢缁勫悕
|MODIFY FILE<
鏂囦欢鏍煎紡
>
|MODIFY FILEGROUP
鏂囦欢缁勫悕
鏂囦欢缁勫睘鎬?/p>
}
<filespec>::=
(NAME=
閫昏緫鏂囦欢鍚?/p>
[
锛?/p>
FILENAME=
鈥樺疄闄呮枃浠跺悕鍜岃矾寰勨�?/p>
]
[
锛?/p>
SIZE=
瀹归噺
]
[
锛?/p>
MAXSIZE={
鏈�澶у閲?/p>
|UNLIMITED}]
[
锛?/p>
FILEGROWTH=
閫掑閲?/p>
]
锛?/p>
涓夈�佸疄楠屽唴瀹癸細
1.
浣跨敤
SQL
璇彞瀹屾垚涓嬮
锛?/p>
1
锛?/p>
浣跨敤
CREATE DATABASE
璇彞鍒涘缓涓�涓悕涓?/p>
鈥?/p>
st
鈥?/p>
鏁版嵁搴擄紝
瑕佹眰鈶犱富瑕佹暟鎹枃浠讹細
閫昏緫鏂囦欢鍚嶄负鈥?/p>
stdata1
鈥?/p>
,
瀹為檯鏂囦欢鍚嶄负鈥?/p>
stdata1.mdf
鈥濃憽浜嬪姟鏃ュ織鏂囦欢锛氶�?/p>
杈戞枃浠跺悕涓衡�?/p>
stlog1
鈥?/p>
,
瀹為檯鏂囦欢鍚嶄负鈥?/p>
stlog1.ldf
鈥濃憿鍒濆瀹归噺鍧囦负
3MB
锛屾渶
澶у閲忓潎涓?/p>
10MB
锛岄�掑閲忓潎涓?/p>
1MB
銆?/p>