Adding file groups to database

Question

How can I add new file groups to an existing database in Microsoft SQL Server 2008?

I see that this is not possible through SSMS?

Milica Medic Kiralj · Accepted Answer · 2014-03-21 18:36:22Z

4

You can add filegroups directly from SSMS. Right-click on a database and go to Properties. In the Database Properties dialog under the Filegroups tab click the Add button and name your filegroup:

enter image description here

To add files to a filegroup, under the Files tab click the Add button and choose the filegroup to which you want to add a file:

enter image description here

You can also use T-SQL e.g.:

ALTER DATABASE [AdventureWorks2012] ADD FILEGROUP [2014]
GO

Hope this helps

answered Mar 21, 2014 at 18:36

Milica Medic Kiralj

3,80833 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Cᴏʀʏ · Accepted Answer · 2014-03-21 18:34:02Z

1

In SSMS, right-click on your database name and choose "Properties." Select the "Filegroups" page. There's an Add button under the Rows section.

answered Mar 21, 2014 at 18:34

Cᴏʀʏ

108k20 gold badges169 silver badges201 bronze badges

Collectives™ on Stack Overflow

Adding file groups to database

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related