SQL Server 2008用T-sql 创建数据库及文件组,出现问题,怎样解决?
//问题在截图中
问题1. “filegroup附近有语法错误”,
问题2.“name附近有语法错误,应为‘SELECT'或‘)’”SQL Server 2008文件组
//问题在截图中
问题1. “filegroup附近有语法错误”,
问题2.“name附近有语法错误,应为‘SELECT'或‘)’”SQL Server 2008文件组
GO
IF DB_ID('Sample_DB') IS NOT NULL
DROP DATABASE [Sample_DB]
CREATE DATABASE [Sample_DB] ON PRIMARY
(
NAME =N'Sample_DB',FILENAME=N'C:\SQLData\Sample_DB.mdf',
SIZE=3072KB,FILEGROWTH=1024KB
), FILEGROUP [FG_1]
(
NAME =N'FG_1_DataFile',FILENAME=N'C:\SQLData\FG_1_DataFile.ndf',
SIZE=3072KB,FILEGROWTH=1024KB
), FILEGROUP [FG_2]
(
NAME =N'FG_2_DataFile',FILENAME=N'C:\SQLData\FG_2_DataFile.ndf',
SIZE=3072KB,FILEGROWTH=1024KB
), FILEGROUP [FG_3]
(
NAME =N'FG_3_DataFile',FILENAME=N'C:\SQLData\FG_3_DataFile.ndf',
SIZE=3072KB,FILEGROWTH=1024KB
), FILEGROUP [FG_N]
(
NAME =N'FG_N_DataFile',FILENAME=N'C:\SQLData\FG_N_DataFile.ndf',
SIZE=3072KB,FILEGROWTH=1024KB
) LOG ON
(
NAME =N'Sample_DB_log',FILENAME=N'C:\SQLData\Sample_DB_log.ldf',
SIZE=3072KB,FILEGROWTH=10%
)
GO