sql server2000实验-数据库专栏,SQL Server-数据库其他-idc中文资讯站-客观公证的IDC产业权威媒体,关注域名、虚拟主机、服务器、网络、开源技术资讯，整合运营商资源，客观评价各地机房带宽线路质量、IDC企业名录等信息

sql server2000实验-数据库专栏,SQL Server

来源：作者：发布时间:2007-12-25 13:52:37

今天做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 = ncredit_data,
      filename = nc:＼program files＼microsoft sql server＼mssql＼data＼credit_data.mdf,
               size = 50,
               filegrowth = 10%)
   log on (name = ncredit_log,
      filename = nc:＼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

喜欢本文，那就收藏到：