|
今天做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
[Access]sql随机抽取记录 [Access]ASP&SQL让select查询结果随机排序的实现方法
[聊天工具]企业邮件系统的利器----FoxMail Server [系统软件]OPEN SERVER 5.0.5安装EXP300阵列柜
[系统软件]SQL语句性能优化--LECCO SQL Expert [系统软件]关于Windows2000Server的灾难恢复
[常用软件][网络]下载服务革命性风暴Poco Server评测 [C语言系列]动态创建SQL Server数据库、表、存储过程等架构信…
[C语言系列]SQL Server到DB2连接服务器的实现 [C语言系列]SQL Server到SYBASE连接服务器的实现
| 
注：本站部分文章源于互联网，版权归原作者所有！如有侵权，请原作者与本站联系，本站将立即删除！ 本站文章除特别注明外均可转载，但需注明出处！ [MinTao学以致用网] 
