NC65创建表空间sql server数据库

我是个假程序员

于 2025-04-03 18:36:13 发布

阅读量151

点赞数 2

分类专栏：数据库文章标签：数据库

本文链接：https://blog.youkuaiyun.com/u010741112/article/details/146986942

版权

数据库专栏收录该内容

51 篇文章

订阅专栏

NC65创建表空间sql server数据库，数据库名，文件名根据自己实际情况修改，这里仅供参考：

USE master;
go
IF DB_ID (N'nchrdb') IS NOT NULL

DROP DATABASE nchrdb;
go

create DATABASE nchrdb
ON PRIMARY
( NAME = N'nchrdb', FILENAME = N'D:\hr_ncdata\nchrdb.mdf', SIZE = 1000 , FILEGROWTH = 200, MAXSIZE = 10000)
LOG ON
(NAME=N'NNC_LOG01',FILENAME=N'D:\hr_ncdata\nnc_log01.Idf',SIZE=10000 ,FILEGROWTH=100,MAXSIZE=50000)
GO
ALTER DATABASE nchrdb ADD FILEGROUP [NNC_DATA01]
go
ALTER DATABASE nchrdb ADD FILEGROUP [NNC_INDEX01]
go

ALTER DATABASE nchrdb ADD FILE(NAME = N'nnc_data01', FILENAME = N'D:\hr_ncdata\nnc_data01_Data.NDF', SIZE = 20000, FILEGROWTH = 200,MAXSIZE = UNLIMITED) TO FILEGROUP [NNC_DATA01]
GO
ALTER DATABASE nchrdb ADD FILE(NAME = N'nnc_index01', FILENAME = N'D:\hr_ncdata\nnc_index01_Data.NDF', SIZE=10000,FILEGROWTH= 200,MAXSIZE =UNLIMITED) TO FILEGROUP [NNC_INDEX01]
go

ALTER DATABASE [nchrdb] MODIFY FILEGROUP [NNC_DATA01] DEFAULT
go
use nchrdb;
go
sp_configure 'show advanced options',1;
GO
RECONFIGURE WITH OVERRIDE;
GO
sp_configure 'max degree of parallelism',1;
GO
RECONFIGURE WITH OVERRIDE;
GO
USE master;
gO

ALTER DATABASE nchrdb SET READ_COMMITTED_SNAPSHOT ON;
GO