Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mohit_sharan
Starting Member
22 Posts |
 Posted - 2005-11-10 : 02:15:19
|
| Hi,In SQL Server 2000 how to move a secondary data file to different filegroup without removing and re-creating the secondary data file.Thanks in advance.-S |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-11-10 : 03:55:48
|
quote:
How to place an existing table on a different filegroup (Enterprise Manager)To place an existing table on a different filegroup Expand a server group, and then expand a server.Expand Databases, expand the database in which the table belongs, and then click Tables.In the details pane, right-click the table, and then click Design Table.Right-click any column, and then click Properties.On the Tables tab, in the Table Filegroup list, select the filegroup on which to place the table.Optionally, in the Text Filegroup list, select a filegroup on which to place any text, image, and ntext columns.
HTH--------------------keeping it simple... |
 |
|
|
|
|
|
Moving Datafile to different filegroup