22,207
社区成员
发帖
与我相关
我的任务
分享
CREATE DATABASE [aaa] ON PRIMARY
( NAME = N'aaa', FILENAME = N'E:\DataBase\aaa.mdf' , SIZE = 3072KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
LOG ON
( NAME = N'aaa_log', FILENAME = N'E:\DataBase\aaa_log.ldf' , SIZE = 2304KB , MAXSIZE = 5120KB , FILEGROWTH = 10%), -- 限制最大5M
( NAME = N'aaa_log2', FILENAME = N'E:\DataBase\aaa_log2.ldf' , SIZE = 2304KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO
USE aaa
GO
CREATE TABLE aaa(a VARCHAR(800))
GO
DECLARE @ix INT
SET @ix=0
WHILE @ix<6000
BEGIN
INSERT INTO aaa VALUES(CAST(@ix AS VARCHAR) + 'asdfasdfas11111fdasdfasdf')
SET @ix = @ix+1
END
go
DELETE FROM aaa
GO
-- 查看数据库日志情况
select groupid, SIZE, [MAXSIZE], growth, [STATUS], [name], [filename] from sysfiles