ALTER DATABASE tempdb
ADD FILE
( NAME = test1dat3,
FILENAME = 'c:\Program Files\Microsoft SQL Server\MSSQL$SQL2000\Data\t1dat3.ndf',
SIZE = 5MB,
MAXSIZE = 100MB,
FILEGROWTH = 5MB),
( NAME = test1dat4,
FILENAME = 'c:\Program Files\Microsoft SQL Server\MSSQL$SQL2000\Data\t1dat4.ndf',
SIZE = 5MB,
MAXSIZE = 100MB,
FILEGROWTH = 5MB)
TO FILEGROUP [default]
ADD FILE
( NAME = test1dat3,
FILENAME = 'c:\Program Files\Microsoft SQL Server\MSSQL$SQL2000\Data\t1dat3.ndf',
SIZE = 5MB,
MAXSIZE = 100MB,
FILEGROWTH = 5MB),
( NAME = test1dat4,
FILENAME = 'c:\Program Files\Microsoft SQL Server\MSSQL$SQL2000\Data\t1dat4.ndf',
SIZE = 5MB,
MAXSIZE = 100MB,
FILEGROWTH = 5MB)
TO FILEGROUP [default]
我已按你的语句扩展了tempdb数据库,但由于select distinct * into ctdtemp..tempdb from mydata处理的数据量比较大,又出现以下错误:
服务器: 消息 1105,级别 17,状态 2,行 1
未能为数据库 'TEMPDB' 中的对象 '(SYSTEM table id: -358130109)' 分配空间,因为文件组 'DEFAULT' 已满。
服务器: 消息 9002,级别 17,状态 1,行 1
数据库 'tempdb' 的日志已满。请备份该数据库的事务日志以释放一些日志空间。