WEB开发网
开发学院数据库MSSQL Server 一个SQLServer2000实验的具体说明 阅读

一个SQLServer2000实验的具体说明

 2007-11-11 10:22:21 来源:WEB开发网   
核心提示:今天做sql server(WINDOWS平台上强大的数据库平台) 2000的一个实验,比较简单的那种,一个SQLServer2000实验的具体说明,新建数据库,修改日志文件的大小等等吧,恩,应该还是比较简单的了

  今天做sql server(WINDOWS平台上强大的数据库平台) 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 Prima(最完善的虚拟主机管理系统)RY (NAME = N'credit_Data',
  FILENAME = N'C:Program FilesMicrosoft sql server(WINDOWS平台上强大的数据库平台)mssql(WINDOWS平台上强大的数据库平台)Datacredit_Data.MDF',
  SIZE = 50,
  FILEGROWTH = 10%)
  LOG ON (NAME = N'credit_Log',
  FILENAME = N'C:Program FilesMicrosoft sql server(WINDOWS平台上强大的数据库平台)mssql(WINDOWS平台上强大的数据库平台)Datacredit_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 FilesMicrosoft sql server(WINDOWS平台上强大的数据库平台)mssql(WINDOWS平台上强大的数据库平台)DataCreditTables.ndf',
  SIZE = 8MB,
  MAXSIZE = UNLIMITED,
  FILEGROWTH = 50MB )
  TO FILEGROUP CreditTablesFG
  ALTER DATABASE credit
  ADD FILE (
  NAME = CreditIndexes,
  FILENAME = 'C:Program FilesMicrosoft sql server(WINDOWS平台上强大的数据库平台)mssql(WINDOWS平台上强大的数据库平台)DataCreditIndexes.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

Tags:一个 SQLServer 实验

编辑录入:coldstar [复制链接] [打 印]
赞助商链接