新手上路 请教如何在不同物理磁盘上创建数据文件,并使他们属于同一个文件组 如题 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 alter database tempdb add file(name='',filename='文件完全路径\文件名.ndf') alter database tempdb add file(name='',filename='文件完全路径\文件名.ndf')这个“add file”是什么意思啊,麻烦能解释一下,最好能多点代码,谢谢 这些问题,新手上路,尽量避免在查询分析器操作。实际中也很少用alter database,用的时候查一查就可以了。 我只所以问这个问题,是因为看到在创建数据库的时候语法是:CREATE DATABASE SalesON PRIMARY( NAME = SPri1_dat, FILENAME = 'c:\program files\microsoft sql server\mssql\data\SPri1dat.mdf', SIZE = 10, MAXSIZE = 50, FILEGROWTH = 15% ),( NAME = SPri2_dat, FILENAME = 'c:\program files\microsoft sql server\mssql\data\SPri2dt.ndf', SIZE = 10, MAXSIZE = 50, FILEGROWTH = 15% ),FILEGROUP SalesGroup1( NAME = SGrp1Fi1_dat, FILENAME = 'c:\program files\microsoft sql server\mssql\data\SG1Fi1dt.ndf', SIZE = 10, MAXSIZE = 50, FILEGROWTH = 5 ),( NAME = SGrp1Fi2_dat, FILENAME = 'c:\program files\microsoft sql server\mssql\data\SG1Fi2dt.ndf', SIZE = 10, MAXSIZE = 50, FILEGROWTH = 5 ),FILEGROUP SalesGroup2( NAME = SGrp2Fi1_dat, FILENAME = 'c:\program files\microsoft sql server\mssql\data\SG2Fi1dt.ndf', SIZE = 10, MAXSIZE = 50, FILEGROWTH = 5 ),( NAME = SGrp2Fi2_dat, FILENAME = 'c:\program files\microsoft sql server\mssql\data\SG2Fi2dt.ndf', SIZE = 10, MAXSIZE = 50, FILEGROWTH = 5 )LOG ON( NAME = 'Sales_log', FILENAME = 'c:\program files\microsoft sql server\mssql\data\salelog.ldf', SIZE = 5MB, MAXSIZE = 25MB, FILEGROWTH = 5MB )GO这里的C是逻辑磁盘,如果是物理磁盘的话,我想了解一下该怎么修改 关于恢复数据库时出现“媒体簇的结构不正确”的问题 !请大家帮帮忙啊! 数据库加密 SQL Server 2005 服务器注册问题 请教高手,如何取得字段值,TKS! 日期之间有几种比较和累加的方法(在线讨教) 请教各位大侠:我的MDX为什么老是连接不到我的服务器? 菜鸟 求教 如何把数据恢复到当前的管理软件中 天,请救救我吧! 这个存储过程怎么写?先谢了!!!!!!!!! 简单问题,求进出差异数 请教一个service broker的问题,谢谢
(name='',filename='文件完全路径\文件名.ndf')
(name='',filename='文件完全路径\文件名.ndf')
这个“add file”是什么意思啊,麻烦能解释一下,最好能多点代码,谢谢
ON PRIMARY
( NAME = SPri1_dat,
FILENAME = 'c:\program files\microsoft sql server\mssql\data\SPri1dat.mdf',
SIZE = 10,
MAXSIZE = 50,
FILEGROWTH = 15% ),
( NAME = SPri2_dat,
FILENAME = 'c:\program files\microsoft sql server\mssql\data\SPri2dt.ndf',
SIZE = 10,
MAXSIZE = 50,
FILEGROWTH = 15% ),
FILEGROUP SalesGroup1
( NAME = SGrp1Fi1_dat,
FILENAME = 'c:\program files\microsoft sql server\mssql\data\SG1Fi1dt.ndf',
SIZE = 10,
MAXSIZE = 50,
FILEGROWTH = 5 ),
( NAME = SGrp1Fi2_dat,
FILENAME = 'c:\program files\microsoft sql server\mssql\data\SG1Fi2dt.ndf',
SIZE = 10,
MAXSIZE = 50,
FILEGROWTH = 5 ),
FILEGROUP SalesGroup2
( NAME = SGrp2Fi1_dat,
FILENAME = 'c:\program files\microsoft sql server\mssql\data\SG2Fi1dt.ndf',
SIZE = 10,
MAXSIZE = 50,
FILEGROWTH = 5 ),
( NAME = SGrp2Fi2_dat,
FILENAME = 'c:\program files\microsoft sql server\mssql\data\SG2Fi2dt.ndf',
SIZE = 10,
MAXSIZE = 50,
FILEGROWTH = 5 )
LOG ON
( NAME = 'Sales_log',
FILENAME = 'c:\program files\microsoft sql server\mssql\data\salelog.ldf',
SIZE = 5MB,
MAXSIZE = 25MB,
FILEGROWTH = 5MB )
GO
这里的C是逻辑磁盘,如果是物理磁盘的话,我想了解一下该怎么修改