关于一个脚本，急救！！！！！

Question

use master
go
create database linedate
on
primary (name=linedata1,
     filename='D:\Microsoft SQL Server\MSSQL\Data\linedata1.mdf',
     size=5MB,
     maxsize=500MB,
     filegrowth=5MB),
     (name=linedata2,
      filename='D:\Microsoft SQL Server\MSSQL\Data\linedata2.ndf',
      size=5MB,
      maxsize=500MB,
      filegrowth=5MB),
     (name=linedata3,
      filename='D:\Microsoft SQL Server\MSSQL\Data\linedata3.ndf',
      size=5MB,
      maxsize=500MB,
      filegrowth=5MB)
log on
      (name=linedatalog1,
       filename='D:\Microsoft SQL Server\MSSQL\Data\linedatalog1.ldf',
       size=2MB,
       maxsize=50MB,
       filegrowth=3MB),
      (name=linedatalog2,
       filename='D:\Microsoft SQL Server\MSSQL\Data\linedatalog2.ldf',
       size=2MB,
       maxsize=50MB,
       filegrowth=3MB)
go

Answer 1

use master
go
create database linedate
on
primary (name=linedata1,  --少了逗号
     FILENAME='D:\Microsoft SQL Server\MSSQL\Data\linedata1.mdf',  --应该用单引号
     size=5MB,
     maxsize=500MB,
     filegrowth=5MB),
     (name=linedata2,
      filename='D:\Microsoft SQL Server\MSSQL\Data\linedata2.ndf',
      size=5MB,
      maxsize=500MB,
      filegrowth=5MB),
     (name=linedata3,
      filename='D:\Microsoft SQL Server\MSSQL\Data\linedata3.ndf',
      size=5MB,
      maxsize=500MB,
      filegrowth=5MB)
log on
      (name=linedatalog1,
       filename='D:\Microsoft SQL Server\MSSQL\Data\linedatalog1.ldf',
       size=2MB,
       maxsize=50MB,
       filegrowth=3MB),
      (name=linedatalog2,
       filename='D:\Microsoft SQL Server\MSSQL\Data\linedatalog2.ldf',
       size=2MB,
       maxsize=50MB,
       filegrowth=3MB)
go