Need to change filegroup of a data file

[unicorn11]

Hi Everybody

I have 3 data files and one log file.
all the data files belong in the same filegroup how do you

1) change the file group of a existing file
2) while adding a new file to the database show that it should be added in a different group.

alter database DBA_Database
add file
(
name=third_file,
filename='d:\sql server\data\thrid_file.ndf',
size=5MB,
maxsize=20MB,
filegrowth=20%)

I am using sql server 2000

regards
Abhishek

Unicorn11
unicorn11@mailcity.com
[red]"Put your hand on a hot stove for a minute, and it seems like an hour. Sit with a pretty girl for an hour, and it seems like a minute. THAT'S relativity." Einstein, Albert[/red]

 

[JayKusch]

I would take a look at BOL. There is a vast wealth of info on the subjects of Files and Filegroups.

Thanks

J. Kusch

 

[unicorn11]

Thanks. found it !!



Unicorn11
unicorn11@mailcity.com
[red]"Put your hand on a hot stove for a minute, and it seems like an hour. Sit with a pretty girl for an hour, and it seems like a minute. THAT'S relativity." Einstein, Albert[/red]