nc安装时创建数据库(MSSQL2005)
USE master;
go
IF DB_ID (N'NCDB') 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 = N'nnc_data01', FILENAME = N'E:\ncdb\nnc_data01_Data.NDF' , SIZE = 50, FILEGROWTH = 20) TO FILEGROUP [NNC_DATA01]
go
ALTER DATABASE [NCDB] ADD FILE(NAME = N'nnc_data02', FILENAME = N'E:\ncdb\nnc_data02_Data.NDF' , SIZE = 50, FILEGROWTH = 20) TO FILEGROUP [NNC_DATA02]
go
ALTER DATABASE [NCDB] ADD FILE(NAME = N'nnc_data03', FILENAME = N'E:\ncdb\nnc_data03_Data.NDF' , SIZE = 50, FILEGROWTH = 20) TO FILEGROUP [NNC_DATA03]
go
ALTER DATABASE [NCDB] ADD FILE(NAME = N'nnc_index01', FILENAME = N'E:\ncdb\nnc_index01_Data.NDF' , SIZE = 20, FILEGROWTH = 10) TO FILEGROUP [NNC_INDEX01]
go
ALTER DATABASE [NCDB] ADD FILE(NAME = N'nnc_index02', FILENAME = N'E:\ncdb\nnc_index02_Data.NDF' , SIZE = 20, FILEGROWTH = 10) TO FILEGROUP [NNC_INDEX02]
go
ALTER DATABASE [NCDB] ADD FILE(NAME = N'nnc_index03', FILENAME = N'E:\ncdb\nnc_index03_Data.NDF' , SIZE = 20, FILEGROWTH = 10) TO FILEGROUP [NNC_INDEX03]
Go
-- 调整临时表空间
declare @name char(50)
declare @sql nvarchar(500)
select @name=rtrim(name) from tempdb.dbo.sysfiles where status & 0x40 != 0x40
set @sql='alter database tempdb modify file ( name='+@name+',size=300mb,filegrowth=10mb)'
exec master.dbo.sp_executesql @sql
----------------------------------------------------------------------------------------------------
select * from tempdb.dbo.sysfiles
go
IF DB_ID (N'NCDB') 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 = N'nnc_data01', FILENAME = N'E:\ncdb\nnc_data01_Data.NDF' , SIZE = 50, FILEGROWTH = 20) TO FILEGROUP [NNC_DATA01]
go
ALTER DATABASE [NCDB] ADD FILE(NAME = N'nnc_data02', FILENAME = N'E:\ncdb\nnc_data02_Data.NDF' , SIZE = 50, FILEGROWTH = 20) TO FILEGROUP [NNC_DATA02]
go
ALTER DATABASE [NCDB] ADD FILE(NAME = N'nnc_data03', FILENAME = N'E:\ncdb\nnc_data03_Data.NDF' , SIZE = 50, FILEGROWTH = 20) TO FILEGROUP [NNC_DATA03]
go
ALTER DATABASE [NCDB] ADD FILE(NAME = N'nnc_index01', FILENAME = N'E:\ncdb\nnc_index01_Data.NDF' , SIZE = 20, FILEGROWTH = 10) TO FILEGROUP [NNC_INDEX01]
go
ALTER DATABASE [NCDB] ADD FILE(NAME = N'nnc_index02', FILENAME = N'E:\ncdb\nnc_index02_Data.NDF' , SIZE = 20, FILEGROWTH = 10) TO FILEGROUP [NNC_INDEX02]
go
ALTER DATABASE [NCDB] ADD FILE(NAME = N'nnc_index03', FILENAME = N'E:\ncdb\nnc_index03_Data.NDF' , SIZE = 20, FILEGROWTH = 10) TO FILEGROUP [NNC_INDEX03]
Go
-- 调整临时表空间
declare @name char(50)
declare @sql nvarchar(500)
select @name=rtrim(name) from tempdb.dbo.sysfiles where status & 0x40 != 0x40
set @sql='alter database tempdb modify file ( name='+@name+',size=300mb,filegrowth=10mb)'
exec master.dbo.sp_executesql @sql
----------------------------------------------------------------------------------------------------
select * from tempdb.dbo.sysfiles