M*****r
发帖数: 1536 | 1 I searched a lot, and the only solution I can find is to:
1. Create cluster index on the new filegroup
2. Delete the cluster index
Is there any other way?
In SQL Server 2K, it can be done in Enterprise manager, but I cannot find
the funcationality now...
Thx! | w*******e
发帖数: 1622 | 2 In SQL2K, 也不能只移one table to a specific filegroup吧
当然在你create table时可以指定一个file group
【在 M*****r 的大作中提到】
: I searched a lot, and the only solution I can find is to:
: 1. Create cluster index on the new filegroup
: 2. Delete the cluster index
: Is there any other way?
: In SQL Server 2K, it can be done in Enterprise manager, but I cannot find
: the funcationality now...
: Thx!
| S***k
发帖数: 370 | 3 As far as I know, it is the only way without any trouble to move an existing
table to a new file group.
【在 M*****r 的大作中提到】
: I searched a lot, and the only solution I can find is to:
: 1. Create cluster index on the new filegroup
: 2. Delete the cluster index
: Is there any other way?
: In SQL Server 2K, it can be done in Enterprise manager, but I cannot find
: the funcationality now...
: Thx!
| n*******a
发帖数: 27 | 4 不行的好象，不能指定FILEGROUP,存储是文件系统管理的,
不知道为什么你CARE ABOUT THAT. | a*******t
发帖数: 891 | 5 probably storage issues
【在 n*******a 的大作中提到】
: 不行的好象，不能指定FILEGROUP,存储是文件系统管理的,
: 不知道为什么你CARE ABOUT THAT.
| M*****r
发帖数: 1536 | 6
这个不算是不合理要求吧
计划没有变化快。。。
【在 n*******a 的大作中提到】
: 不行的好象，不能指定FILEGROUP,存储是文件系统管理的,
: 不知道为什么你CARE ABOUT THAT.
|
|
