use master
go
on(
create database 11071156,
name=11071156_dat,
filename='c:\1107115611.ndf',
size=5MB,
maxsize=10MB,
filegrowth=5MB
)
log on
(name='Sales_log',
filename='c:\11071156log.ldf',
size=5MB,
maxsize=25MB,
filegrowth=5MB
)
go
use master
go
create database Array
on primary
(name=Array1,
filename='c:\Array2.mdf,
size=5MB,
maxsize=200,
filegrowth=20),
(name=Array3,
filename='c:\Array3.ndf',
size=100MB,
maxsize=200,
filegrowth=20)
log on
(name=Array4,
filename='c:\array.ldf',
size=100Mb,
maxsize=200,
filegrowth=20)
go
|