一个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
更多精彩
赞助商链接