日期:2014-05-17 浏览次数:20422 次
use master
go
create database student_mis
on
(name=studengt_data,
filename='c:\program files\microsoft sql server\student_mis_data.mdf',
size=10,
maxsize=50,
filegrowth=5)
log on
(name='student_log',
filename='c:\program files\microsoft sql server\student_mis_log.ldf',
size=5MB,
maxsize=25MB,
filegrowth=5MB)
go
USE master;
GO
CREATE DATABASE Sales
ON
( NAME = Sales_dat,
FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\saledat.mdf',
SIZE = 10,
MAXSIZE = 50,
FILEGROWTH = 5 )
LOG ON
( NAME = Sales_log,
FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\salelog.ldf',
SIZE = 5MB,
MAXSIZE = 25MB,
FILEGROWTH = 5MB ) ;
GO
use master
go
create database student_mis
on
(name=studengt_data,
filename='c:\program files\microsoft sql server\student_mis_data.mdf',
size=10,
maxsize=50,
filegrowth=5)
log on
(name='student_log',
filename='c:\program files\microsoft sql server\student_mis_log.ldf',
size=5MB,
maxsize=25MB,
filegrowth=5MB)
go
use student_mis
go