where to I set up secondary files group

[APOC9109]

I try to create a db in enteprose manager and choose to create a seconday.ndf files but it will not let me put in another file group other than primary. how do you create a secondary file group so i can create and save a .ndf file to the group?

 

[mrdenny]

On the filegroup tab.

In EM you have to add the file group, click ok then go back into the properties to add a file to the group.

This has been fixed in the SQL 2005 GUI.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com