当前位置导航:炫浪网>>网络学院>>编程开发>>MsSQL教程

一个SQL Server 2000实验的具体说明


  今天做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
相关内容
赞助商链接