今天做sql server 2000的一个实验，比较简单的那种，新建数据库，修改日志文件的大小等等吧，恩，应该还是比较简单的了。下面还是记录一下啦~都这么就没有来过了的。

/*
**  CREABASE.SQL
**
**  Drop and Rereate the credit database.  Record the time required.
*/

PRINT ''''Begin CREABASE.SQL''''
GO

USE master
SET nocount ON
GO

IF db_id(''''credit'''') IS NOT NULL
   DROP DATABASE credit
GO

CREATE DATABASE [credit] 
   ON PRIMARY (NAME = N''''credit_Data'''',
      FILENAME = N''''C:\Program Files\Microsoft SQL Server\MSSQL\Data\credit_Data.MDF'''',
               SIZE = 50,
               FILEGROWTH = 10%)
   LOG ON (NAME = N''''credit_Log'''',
      FILENAME = N''''C:\Program Files\Microsoft SQL Server\MSSQL\Data\credit_Log.LDF'''',
           SIZE = 1,
           FILEGROWTH = 10%)
GO

ALTER DATABASE credit
   ADD FILEGROUP CreditTablesFG
GO
ALTER DATABASE credit
   ADD FILEGROUP CreditIndexesFG
GO
ALTER DATABASE credit
   ADD FILE (
      NAME = CreditTables,
      FILENAME = ''''C:\Program Files\Microsoft SQL Server\MSSQL\Data\CreditTables.ndf'''',
      SIZE = 8MB,
      MAXSIZE = UNLIMITED,
      FILEGROWTH = 50MB )
   TO FILEGROUP CreditTablesFG
ALTER DATABASE credit
   ADD FILE (
      NAME = CreditIndexes,
      FILENAME = ''''C:\Program Files\Microsoft SQL Server\MSSQL\Data\CreditIndexes.ndf'''',
      SIZE = 8MB,
      MAXSIZE = UNLIMITED,
      FILEGROWTH = 50MB )
   TO FILEGROUP CreditIndexesFG
GO

PRINT '''' ''''
IF db_id(''''credit'''') IS NOT NULL
   PRINT ''''CREATED DATABASE "credit"''''
ELSE
   PRINT ''''CREATE DATABASE "credit" FAILED''''
PRINT '''' ''''
GO

/*
**  This script sets the database recovery model to SIMPLE
**  for the ClassNorthwind database. Simple Recovery allows
**  the database to be recovered to the most recent backup.
**
**  Look under the status column of your sp_helpdb results to
**  view the recovery model that has been set for a database.
*/

USE ClassNorthwind

ALTER DATABASE ClassNorthwind SET RECOVERY SIMPLE

EXEC sp_helpdb ClassNorthwind
GO

/*
This script modifies the maximum size of the ClassNorthwind transaction log file
and increases its current size.
*/

USE master
GO

ALTER DATABASE ClassNorthwind
  MODIFY FILE (NAME=''''ClassNorthwind_Log'''',
        MAXSIZE=50MB)
GO

ALTER DATABASE ClassNorthwind
  MODIFY FILE (NAME=''''ClassNorthwind_Log'''',
        SIZE=25MB)
GO
ALTER DATABASE ClassNorthwind
  MODIFY FILE (NAME=''''ClassNorthwind_Log'''',
        FILEGROWTH=20%)
GO

EXEC sp_helpdb ClassNorthwind
GO

Copyright ＠ 2007 MinTao学以致用网（www.mintao.net） Inc All Rights Reserved.
QQ：543098146 QQ：261561092　QQ：179647303 MSN:min906@126.com
站长：MinTao 信息产业部ICP备案号:鄂ICP备07500065号