Create datebase－時機律動來往間

Mar 12 Tue 2013 08:37
Create datebase

CREATE DATABASE [DemoDB]
CONTAINMENT = NONE
ON PRIMARY
(
NAME = N'DemoDB',
FILENAME = N'D:\LocalDB\DemoDB.MDF',
SIZE = 3072KB,
FILEGROWTH = 1024KB
)
LOG ON
(
NAME = N'DemoDB_log',
FILENAME = N'D:\LocalDB\DemoDB_Log.LDF',
SIZE = 1024KB,
FILEGROWTH = 10%
)
GO

USE [DemoDB]
GO
IF NOT EXISTS (SELECT name FROM sys.filegroups WHERE is_default=1 AND name = N'PRIMARY')
ALTER DATABASE [DemoDB] MODIFY FILEGROUP [PRIMARY] DEFAULT
GO