·¢²¼Ê±¼ä : ÐÇÆÚËÄ ÎÄÕÂÊý¾Ý¿âÔÀíÓëSQLServer¿Î³ÌʵÑ鱨¸æ¸üÐÂÍê±Ï¿ªÊ¼ÔĶÁ
ʵÑé2 Êý¾Ý¿â¹ÜÀí
Ä¿µÄºÍÒªÇó
£¨1£© Á˽âSQL ServerÊý¾Ý¿âµÄÂß¼½á¹¹ºÍÎïÀí½á¹¹ £¨2£© Á˽â±íµÄ½á¹¹ºÍÌص㠣¨3£© Á˽âSQL Server µÄ»ù±¾Êý¾ÝÀàÐÍ £¨4£© Á˽â¿ÕÖµ¸ÅÄî £¨5£© ѧ»áÔÚÆóÒµ¹ÜÀíÆ÷Öд´½¨Êý¾Ý¿âºÍ±í £¨6£© ѧ»áʹÓÃT-SQL Óï¾ä´´½¨¡¢ÐÞ¸ÄÊý¾Ý¿âºÍ±í
ʵÑé×¼±¸
£¨1£©Ã÷È·´´½¨Êý¾Ý¿âµÄÓû§±ØÐëÊÇϵͳ¹ÜÀíÔ±£¬»òÊDZ»ÊÚȨʹÓÃCREATE DATABASEÓï¾äµÄÓû§¡£ £¨2£©´´½¨Êý¾Ý¿â±ØÐëҪȷ¶¨Êý¾Ý¿âÃû¡¢Êý¾Ý¿â´óС£¨×î³õµÄ´óС¡¢×î´óµÄ´óС¡¢ÊÇ·ñÔÊÐíÔö³¤¼´Ôö³¤·½Ê½£©ºÍ´æ´¢Êý¾ÝµÄÎļþ¡£
£¨3£©È·¶¨Êý¾Ý¿â°üº¬ÄÄЩ±í£¬ÒÔ¼°Ëù°üº¬µÄ¸ö±íµÄ½á¹¹£¬»¹ÒªÁ˽âSQL ServerµÄ³£ÓÃÊý¾ÝÀàÐÍ£¬ÒÔ´´½¨Êý¾Ý¿âµÄ±í¡£
£¨4£©Á˽âÁ½ÖÖ³£ÓõĴ´½¨Êý¾Ý¿â¡¢±íµÄ·½·¨£¬¼´ÔÚÆóÒµ¹ÜÀíÆ÷Öд´½¨ºÍʹÓÃT-SQLÓï¾ä´´½¨¡£
ʵÑéÄÚÈݼ°½á¹û
1. ´´½¨test1Êý¾Ý¿â£¬Âß¼ÎļþÃûΪtestdata £¬Êý¾ÝÎļþÃûΪtest1data.mdf£¬³õʼÈÝÁ¿Îª1MB£¬×î´óÈÝÁ¿Îª10MB£¬¿Õ¼ä´óС°´10%µÝÔö¡£
¢ÙSQLÃüÁ
CREATE DATABASE test1 ON
(NAME=testdata,
FILENAME='D:\\data1\\test1data.mdf', SIZE=1MB, MAXSIZE=10MB, FILEGROWTH=10% )
3
¢Ú½á¹û
2. ´´½¨test2Êý¾Ý¿â£¬Âß¼Ö÷Êý¾ÝÎļþÃûΪtestdata£¬´æ·ÅÔÚÎļþ¼Ð¡°D:\\text¡±ÖУ¬Êý¾ÝÎļþÃûΪtest2data.mdf£¬ÈÕÖ¾ÎļþÃûΪtest2data.ldf£¬³õʼÈÝÁ¿Îª2MB£¬×î´óÈÝÁ¿Îª20MB£¬µÝÔö´óСΪ2MB¡£
¢ÙSQLÃüÁ
CREATE DATABASE test2 ON
(NAME=testdata,
FILENAME='D:\\text\\test2data.mdf', SIZE=1MB,
MAXSIZE=10MB, FILEGROWTH=10% )
LOG ON
(NAME=test2data,
FILENAME='D:\\text\\test2data.ldf', SIZE=2MB,
MAXSIZE=20MB, FILEGROWTH=2MB)
¢Ú½á¹û£º
4
3. ÐÞ¸Ätest2Êý¾Ý¿â£¬Ìí¼ÓÁ½¸ö´ÎÊý¾ÝÎļþtest_add1ºÍtest_add2£¬ËûÃǵijõʼ´óСΪ10MB£¬²»ÔÊÐí×Ô¶¯Ôö³¤¿Õ¼ä¡£½«test2Êý¾Ý¿âÖеÄtest2dataÖ÷Êý¾ÝÎļþµÄ³õʼ´óСÐÞ¸ÄΪ5MB£¬Ìí¼ÓÒ»¸öÈÕÖ¾Îļþtest2log.ldf£¬³õʼÈÝÁ¿Îª1MB£¬×î´óÈÝÁ¿Îª5MB£¬¿Õ¼ä´óС°´10%µÝÔö¡£
¢ÙSQLÃüÁ alter database test2 add file(
name=test_add1,
filename='D:\\text\\test_add1.ndf', size=10mb) go
alter database test2 add file(
name=test_add2,
filename='D:\\text\\test_add2.ndf', size=5mb) go
alter database test2 add log file( name=test2log,
filename='D:\\text\\test2log.ldf', size=1mb, maxsize=5mb, filegrowth=10%)
¢Ú½á¹û£º
5
4. ѹËõtest2Êý¾Ý¿âÎļþΪÔÀ´µÄ20%¡£
¢ÙSQLÃüÁ
dbcc shrinkdatabase(test2,20) ¢Ú½á¹û£º
5. ɾ³ýtest1Êý¾Ý¿â¡£
¢ÙSQLÃüÁ
drop database test1 ¢Ú½á¹û£º
6. ´´½¨Ãû³ÆΪ¡°Í¨Ñ¶Â¼¡±Êý¾Ý¿â£¬²¢ÔÚ¸ÃÊý¾Ý¿âÖд´½¨ÃûΪ¡°¸öÈËÐÅÏ¢¡±µÄÊý¾Ý±í£¬°üÀ¨ÈçÏÂ×ֶΣº±àºÅ£¨int£¬×Ô¶¯±àºÅ£©¡¢ÐÕÃû£¨char£¨8£©not null£©¡¢ÐÔ±ð£¨char£¨2£©not null£©¡¢³öÉúÈÕÆÚ£¨datetime£©¡¢ÁªÏµ·½Ê½£¨char£¨16£©£©¡£ ¢ÙSQLÃüÁ
create database ͨѶ¼
on( name=Êý¾Ý¿â_data,filename=¡¯D:\\sqldata\\Êý¾Ý¿â_data.mdf¡¯) go
create table ¸öÈËÐÅÏ¢
( ±àºÅ int identity(100,1) primary key , ÐÕÃû char (8) not null, ÐÔ±ð char (2) not null, ³öÉúÈÕÆÚ datetime, ÁªÏµ·½Ê½ char (16) )
6