今天做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 |
 |