createdatabase.sql

此软件是一个 日志服务器

--创建数据库】
IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'SysLog_SYS')
	DROP DATABASE [SysLog_info]
GO

create database SysLog_info
ON (
	name = personnel_info ,
	filename = 'D:\SqlData\SysLog_info.mdf',
	size = 10mb ,
	maxsize = 500mb ,
	filegrowth = 10 mb
)
log on (
	name = personnel_log ,
	filename = 'D:\SqlData\SysLog_info.ldf',
	size = 10mb ,
	maxsize = 500mb ,
	filegrowth = 10 mb	
)