NC61+SQLSERVER2008R2执行脚本

9099198

新人学习安装NC61，数据库用的是sql sever2008r2  测试都通过了，用root登录在安装数据库是出现错误，提示如下

唐二毛

楼主是2个表空间文件吧？

唐二毛

改成6个表空间文件估计就好了。

唐二毛

USE master
go
IF DB_ID (N'NC63') IS NOT NULL
DROP DATABASE [NC63]
go
CREATE DATABASE [NC63]
go
ALTER DATABASE [NC63] ADD FILEGROUP [NNC_DATA01]
go
ALTER DATABASE [NC63] ADD FILEGROUP [NNC_DATA02]
go
ALTER DATABASE [NC63] ADD FILEGROUP [NNC_DATA03]
go
ALTER DATABASE [NC63] ADD FILEGROUP [NNC_INDEX01]
go
ALTER DATABASE [NC63] ADD FILEGROUP [NNC_INDEX02]
go
ALTER DATABASE [NC63] ADD FILEGROUP [NNC_INDEX03]
go
ALTER DATABASE [NC63] ADD FILE(NAME = N'nnc_data01', FILENAME = N'D:\NC\nnc_data01_Data.NDF' , SIZE = 500, FILEGROWTH = 200) TO FILEGROUP [NNC_DATA01]
go
ALTER DATABASE [NC63] ADD FILE(NAME = N'nnc_data02', FILENAME = N'D:\NC\nnc_data02_Data.NDF' , SIZE = 500, FILEGROWTH = 200) TO FILEGROUP [NNC_DATA02]
go
ALTER DATABASE [NC63] ADD FILE(NAME = N'nnc_data03', FILENAME = N'D:\NC\nnc_data03_Data.NDF' , SIZE = 500, FILEGROWTH = 200) TO FILEGROUP [NNC_DATA03]
go
ALTER DATABASE [NC63] ADD FILE(NAME = N'nnc_index01', FILENAME = N'D:\NC\nnc_index01_Data.NDF' , SIZE = 500, FILEGROWTH = 100) TO FILEGROUP [NNC_INDEX01]
go
ALTER DATABASE [NC63] ADD FILE(NAME = N'nnc_index02', FILENAME = N'D:\NC\nnc_index02_Data.NDF' , SIZE = 500, FILEGROWTH = 100) TO FILEGROUP [NNC_INDEX02]
go
ALTER DATABASE [NC63] ADD FILE(NAME = N'nnc_index03', FILENAME = N'D:\NC\nnc_index03_Data.NDF' , SIZE = 500, FILEGROWTH = 100) 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=600mb,filegrowth=10mb)'
       exec master.dbo.sp_executesql @sql

唐二毛

D:\NC\这个地址一定要改成实际文件夹