CREATE DATABASE test1
ON
( NAME = test_data,
FILENAME = 'D:\mssq1\data\test1_data.mdf',
SIZE = 1,
MAXSIZE = 50,
FILEGROWTH = 1 )
LOG ON
( NAME = 'test1_log',
FILENAME = 'D:\mssq1\data\test1_data.ldf',
SIZE = 1MB,
MAXSIZE = 10MB,
FILEGROWTH = 1MB )
GO
ON
( NAME = test_data,
FILENAME = 'D:\mssq1\data\test1_data.mdf',
SIZE = 1,
MAXSIZE = 50,
FILEGROWTH = 1 )
LOG ON
( NAME = 'test1_log',
FILENAME = 'D:\mssq1\data\test1_data.ldf',
SIZE = 1MB,
MAXSIZE = 10MB,
FILEGROWTH = 1MB )
GO
ON
( NAME = test_data,
FILENAME = 'D:\mssq1\data\test1_data.mdf',
SIZE = 1,
MAXSIZE = 50,
FILEGROWTH = 1 )
LOG ON
( NAME = 'test1_log',
FILENAME = 'D:\mssq1\data\test1_log.ldf',
SIZE = 1MB,
MAXSIZE = 10MB,
FILEGROWTH = 1MB )
GO
ON
( NAME = test_data,
FILENAME = 'd:\mssql\data\test1_data.mdf',
SIZE = 1,
MAXSIZE = 10,
FILEGROWTH = 1 )
GO
ON
( NAME = test_data,
FILENAME = 'd:\mssql\data\test1_data.mdf',
SIZE = 1,
MAXSIZE = 10,
FILEGROWTH = 1 )
GO
ON
( NAME = test_data,
FILENAME = 'D:\mssq1\data\test1_data.mdf',
SIZE = 1,
MAXSIZE = 10,
FILEGROWTH = 1 )
LOG ON
( NAME = 'test1_log',
FILENAME = 'D:\mssq1\data\test1_data.ldf',
SIZE = 1MB,
MAXSIZE = 10MB,
FILEGROWTH = 1MB )
GO
ON
( NAME = test_data,
FILENAME = 'D:\mssq1\data\test1_data.mdf',
SIZE = 1,
MAXSIZE = 10,
FILEGROWTH = 1 )
LOG ON
( NAME = 'test1_log',
FILENAME = 'D:\mssq1\data\test1_data.ldf',
SIZE = 1MB,
MAXSIZE = 10MB,
FILEGROWTH = 1MB )
GO