1、USEmaster;goIFDB_ID(NNCDB)ISNOTNULLDROPDATABASENCDB;goCREATEDATABASENCDBgoALTERDATABASNCDqADDFILEGROUPNNC_DATA01goALTERDATABASNCDqADDFILEGROUPNNC_DATA02goALTERDATABASNCDqADDFILEGROUPNNC_DATA03goALTERDATABASNCDqADDFILEGROUPNNC_INDEX01goALTERDATABASNCDqADDFILEGROUPNNC_INDEX02goALTERDATABASNCDqADDFILEG

2、ROUPNNC_INDEX03goALTERDATABASENCDEADDFILE(NAME=Nnnc_data01,FILENAME=ND:MicrosoftSQLServerMSSQL$SQL1dat演nnc_data01_Data.NDF,SIZE=500,FILEGROWTH=200)TOFILEGROUPNNC_DATA01goALTERDATABASENCDEADDFILE(NAME=Nnnc_data02,FILENAME=ND:MicrosoftSQLServerMSSQL$SQL1datannc_data02_Data.NDF,SIZE=500,FILEGROWTH=200)

3、TOFILEGROUPNNC_DATA02goALTERDATABASENCDBADDFILE(NAME=Nnnc_data03,FILENAME=ND:MicrosoftSQLServerMSSQL$SQL1datannc_data03_Data.NDF,SIZE=500,FILEGROWTH=200)TOFILEGROUPNNC_DATA03goALTERDATABASE；NCDBIADDFILE(NAME=Nnnc_index01,FILENAME=ND:MicrosoftSQLServerMSSQL$SQL1dat和nc_index01_Data.NDF,SIZE=200,FILEGR

4、OWTH=100)TOFILEGROUPNNC_INDEX01goALTERDATABASE；NCDBIADDFILE(NAME=Nnnc_index02,FILENAME=ND:MicrosoftSQLServerMSSQL$SQL1dat和nc_index02_Data.NDF,SIZE=200,FILEGROWTH=100)TOFILEGROUPNNC_INDEX02goALTERDATABASE；NCDBIADDFILE(NAME=Nnnc_index03,FILENAME=ND:MicrosoftSQLServerMSSQL$SQL1datannc_index03_Data.NDF,

5、SIZE=200,FILEGROWTH=100)TOFILEGROUPNNC_INDEX03IGo1、新建表空間以上為執行腳本，紅色部分需更改，NCDB改為自己想要創建的數據庫名稱，地址改為存放表空間的地址新建查詢也行地址要自己創建，盡量在系統盤南樂-工亨-濟井片汽:市點=老件*SEfcE1?medBtaffilDita.NDF司仃M&15548SQLServerData川5L2M0KB面IPfr-r-rtJrt#nJ_pptj.hdW17/11614BSQLXrwr511,000KH工標工由此吱丘lPftc.at4OS.DdiJ.NDf7也JfUIG1343SQL3v*rOaUm5UOOOK

6、B學jindrL的加凡口?/W7R101549SQLSewr口電仍引2Q4J0DKBi左3L?ML_i,7*Q2_l*u.H0F2017,0716154SQLSivtrDjldh.204,14X)1KBl_pr_indfr3S_DaTfl.Npf2017MB1M9SQL54rM堂rggf204&D0KBL計苜皿匚SisiEa（C：）.J不啪兒叫.,可始3（r：j4局珞完成后顯示如下2-新建用戶一一右鍵安全性下的登錄名新建用戶般勾PUBLIC勾選sysadmin會擁有所有權限按需要勾選需要權限的數據庫:錄名-新建-l丁萬，一x1:Jbm12）花助/希芬蕓年自愣主戶則；身伙志映月閆出登船名的田戶西ng,。rastervoidITsib1T3FJVheportServerEo,wtScrwTspnB泳格已啟用Quest帳戶：qpLe數據摩角色成員身份:arpU遑推4db_accessadninn_backugoperato