22,209
社区成员
发帖
与我相关
我的任务
分享
set rowcount 100
USE [master]
GO
/******Object: Database [Data PartitionDB] Script Date: 10/08/2006 23:09:53******/
IF EXISTS (SELECT name FROM sys.databases WHERE name = N'Data Partition DB2')
DROP DATABASE [Data Partition DB2]
GO
CREATE DATABASE [Data Partition DB2]
ON PRIMARY
(NAME='DataPartition DB Primary FG',
FILENAME=
'F:\Data2\Primary\DataPartition DB Primary FG.mdf',
SIZE=5,
MAXSIZE=500,
FILEGROWTH=1 ),
FILEGROUP [Data Partition DB FG1]
(NAME = 'DataPartition DB FG1',
FILENAME =
'F:\Data2\FG1\DataPartition DB FG1.ndf',
SIZE = 5MB,
MAXSIZE=500,
FILEGROWTH=1 ),
FILEGROUP [Data Partition DB FG2]
(NAME = 'DataPartition DB FG2',
FILENAME =
'F:\Data2\FG2\DataPartition DB FG2.ndf',
SIZE = 5MB,
MAXSIZE=500,
FILEGROWTH=1 ),
FILEGROUP [Data Partition DB FG3]
(NAME = 'DataPartition DB FG3',
FILENAME =
'F:\Data2\FG3\DataPartition DB FG3.ndf',
SIZE = 5MB,
MAXSIZE=500,
FILEGROWTH=1 ),
FILEGROUP [Data Partition DB FG4]
(NAME = 'DataPartition DB FG4',
FILENAME =
'F:\Data2\FG4\DataPartition DB FG4.ndf',
SIZE = 5MB,
MAXSIZE=500,
FILEGROWTH=1 )