sql建表空间及新建用户操作手册.docxVIP

  • 19
  • 0
  • 约1.72千字
  • 约 7页
  • 2018-08-04 发布于浙江
  • 举报
sql建表空间及新建用户操作手册

USE master; go IF DB_ID (NNCDB) IS NOT NULL DROP DATABASE [NCDB]; go CREATE DATABASE [NCDB] go ALTER DATABASE [NCDB] ADD FILEGROUP [NNC_DATA01] go ALTER DATABASE [NCDB] ADD FILEGROUP [NNC_DATA02] go ALTER DATABASE [NCDB] ADD FILEGROUP [NNC_DATA03] go ALTER DATABASE [NCDB] ADD FILEGROUP [NNC_INDEX01] go ALTER DATABASE [NCDB] ADD FILEGROUP [NNC_INDEX02] go ALTER DATABASE [NCDB] ADD FILEGROUP [NNC_INDEX03] go ALTER DATABASE [NCDB] ADD FILE(NAME = Nnnc_data01, FILENAME = ND:\Microsoft SQL Server\MSSQL$SQL1\data\nnc_data01_Data.NDF , SIZE = 500, FILEGROWTH = 200) TO FILEGROUP [NNC_DATA01] go ALTER DATABASE [NCDB] ADD FILE(NAME = Nnnc_data02, FILENAME = ND:\Microsoft SQL Server\MSSQL$SQL1\data\nnc_data02_Data.NDF , SIZE = 500, FILEGROWTH = 200) TO FILEGROUP [NNC_DATA02] go ALTER DATABASE [NCDB] ADD FILE(NAME = Nnnc_data03, FILENAME = ND:\Microsoft SQL Server\MSSQL$SQL1\data\nnc_data03_Data.NDF , SIZE = 500, FILEGROWTH = 200) TO FILEGROUP [NNC_DATA03] go ALTER DATABASE [NCDB] ADD FILE(NAME = Nnnc_index01, FILENAME = ND:\Microsoft SQL Server\MSSQL$SQL1\data\nnc_index01_Data.NDF , SIZE = 200, FILEGROWTH = 100) TO FILEGROUP [NNC_INDEX01] go ALTER DATABASE [NCDB] ADD FILE(NAME = Nnnc_index02, FILENAME = ND:\Microsoft SQL Server\MSSQL$SQL1\data\nnc_index02_Data.NDF , SIZE = 200, FILEGROWTH = 100) TO FILEGROUP [NNC_INDEX02] go ALTER DATABASE [NCDB] ADD FILE(NAME = Nnnc_index03, FILENAME = ND:\Microsoft SQL Server\MSSQL$SQL1\data\nnc_index03_Data.NDF , SIZE = 200, FILEGROWTH = 100) TO FILEGROUP [NNC_INDEX03] Go 1、新建表空间 以上为执行脚本,红色部分需更改,NCDB 改为自己想要创建的数据库名称,地址改为存放表空间的地址 新建查询-执行 地址要自己创建,尽量在系统盘 完成后显示如下 2、新建用户——右键安全性下的[登录名]新建用户 一般勾 PUBLIC 勾选sysadmin会拥有所有权限 , 按需要勾选 需要权限的数据库 确认即可

文档评论(0)

1亿VIP精品文档

相关文档