缁冧範棰?/p>
1鈥?/p>
鏁版嵁搴撳垱寤轰笌绠＄悊
1.
璇峰湪绌虹櫧澶勫～鍐欏悎閫傜殑鍐呭锛屼互瀹屽杽涓嬪垪璇彞銆?/p>
锛?/p>
1
锛夊垱寤轰竴涓悕涓?/p>
company
鐨勭敤鎴锋暟鎹簱銆傚叾鏁版嵁鏂囦欢鐨勫垵濮嬪ぇ灏忎负
10MB
锛?/p>
鏃犳渶澶ч檺鍒讹紝浠?/p>
10%
鐨勯�熷害澧為暱銆傛棩蹇楁枃浠剁殑鍒濆澶у皬涓?/p>
1MB
锛屾渶澶т负
5MB
锛?/p>
浠?/p>
1MB
鐨勯�熷害澧為暱銆?/p>
create
database
on primary
锛?/p>
name=company_data,
filename=鈥楧:\MSSQL\DATA\company.mdf',
SIZE=
,
MAXSIZE =
,
FILEGROWTH=
)
log on
(name=company_log,
filename=鈥楧:\MSSQL\DATA\company.ldf',
SIZE=
,
MAXSIZE =
,
FILEGROWTH=
)
(2)
灏?/p>
company
鏁版嵁搴撹缃负鍙鐘舵�併�?/p>
EXEC
SP_DBOPTION
鈥?nbsp;
鈥? 鈥?nbsp;
鈥?鈥檛rue鈥?/p>
(3)
灏?/p>
company
鏁版嵁搴撶殑鍒濆鍒嗛厤绌洪棿澶у皬鎵╁厖鍒?/p>
20MB
銆?/p>
ALTER DATABASE
MODIFY FILE
(NAME=
,
SIZE=
)
(4)
灏?/p>
company
鐢ㄦ埛鏁版嵁搴撴敼鍚嶄负
corporation
銆?/p>
EXEC
SP_DBOPTION
鈥榗ompany 鈥? 鈥?nbsp;
鈥? 鈥榯rue鈥?/p>
EXEC
鈥榗ompany 鈥? 鈥榗orporation鈥?/p>
EXEC
SP_DBOPTION
鈥榗orporation鈥? 鈥榮ingle user鈥? 鈥?nbsp;
鈥?/p>
(5)
灏?/p>
corporation
鏁版嵁搴撶殑绌洪棿鍘嬬缉鑷虫渶灏忓閲忋�?/p>
(鈥榗orporation鈥?
(6
锛夊垹闄?/p>
corporation
鏁版嵁搴撱�?/p>
corporation
2.
绠�绛旈
锛?/p>
1
锛?/p>
SQL Server
涓寘鍚簡鍝袱绉嶇被鍨嬬殑鏁版嵁搴擄紵