sql建表空間及新建用戶操作手冊

1、USE master;goIF DB_ID (N'NCDB') IS NOT NULLDROP DATABASE NCDB;goCREATE DATABASE NCDBgo ALTER DATABASE NCDB ADD FILEGROUP NNC_DATA01goALTER DATABASE NCDB ADD FILEGROUP NNC_DATA02goALTER DATABASE NCDB ADD FILEGROUP NNC_DATA03goALTER DATABASE NCDB ADD FILEGROUP NNC_INDEX01goALTER DATABASE NCDB

2、ADD FILEGROUP NNC_INDEX02goALTER DATABASE NCDB ADD FILEGROUP NNC_INDEX03goALTER DATABASE NCDB ADD FILE(NAME = N'nnc_data01', FILENAME = N'D:Microsoft SQL ServerMSSQL$SQL1datannc_data01_Data.NDF' , SIZE = 500, FILEGROWTH = 200) TO FILEGROUP NNC_DATA01goALTER DATABASE NCDB ADD FILE(NAM

3、E = N'nnc_data02', FILENAME = N'D:Microsoft SQL ServerMSSQL$SQL1datannc_data02_Data.NDF' , SIZE = 500, FILEGROWTH = 200) TO FILEGROUP NNC_DATA02goALTER DATABASE NCDB ADD FILE(NAME = N'nnc_data03', FILENAME = N'D:Microsoft SQL ServerMSSQL$SQL1datannc_data03_Data.NDF' ,

4、 SIZE = 500, FILEGROWTH = 200) TO FILEGROUP NNC_DATA03goALTER DATABASE NCDB ADD FILE(NAME = N'nnc_index01', FILENAME = N'D:Microsoft SQL ServerMSSQL$SQL1datannc_index01_Data.NDF' , SIZE = 200, FILEGROWTH = 100) TO FILEGROUP NNC_INDEX01goALTER DATABASE NCDB ADD FILE(NAME = N'nnc_i

5、ndex02', FILENAME = N'D:Microsoft SQL ServerMSSQL$SQL1datannc_index02_Data.NDF' , SIZE = 200, FILEGROWTH = 100) TO FILEGROUP NNC_INDEX02goALTER DATABASE NCDB ADD FILE(NAME = N'nnc_index03', FILENAME = N'D:Microsoft SQL ServerMSSQL$SQL1datannc_index03_Data.NDF' , SIZE = 200, FILEGROWTH = 100) TO FILEGROUP NNC_INDEX03Go1、新建表空間以上為執(zhí)行腳本，紅色部分需更改，NCDB 改為自己想要?jiǎng)?chuàng)建的數(shù)據(jù)庫名稱，地址改為存放表空間的地址新建查詢-執(zhí)行地址要自