SQL Server changes the database with the command line

(It should be 154 Blue House only)

CREATE database name

On [PRIMARY]

(

< data file parameters > [, ... n] [< file group parameters;]

)

[LOG on]

(

< log file parameters > [, ... n]

CREATE DATABASE Studb

On PRIMARY--The default is the PRIMARY primary filegroup, which can be omitted

(

Name= ' Studb_data ',--the logical name of the master data file

Filename= ' D:\project\stuDB_data.mdf ',--the physical name of the master data file

SIZE=5MB,--Primary data file Initial size

MAXSIZE=100MB,--Maximum value of master data file growth

filegrowth=15%--Growth rate of master data files

)

LOG on

(

Name= ' Studb_log ',

Filename= ' D:\project\stuDB_log.ldf ',

SIZE=2MB,

Filegrowth=1mb

)

GO

LOG on

(

/*-specific description of log file 1-*/

NAME = ' Employeelog1 ',

FILENAME = ' D:\project\employeelog1_Log.ldf ',

SIZE = 10,

FILEGROWTH = 1

),

(

/*-specific description of log file 2-*/

NAME = ' employeelog2 ',

FILENAME = ' D:\project\employeelog2_Log.ldf ',

SIZE = 10,

MAXSIZE = 50,

FILEGROWTH = 1

)

GO

,

Use master--set the current database to master for access to the sysdatabases table

GO

IF EXISTS (SELECT * from sysdatabases WHERE name = ' Studb ')

DROP DATABASE Studb

CREATE DATABASE Studb

On (

.....

)

LOG on

(

...

)

GO

SQL Server changes the database with the command line