1

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?

Cᴏʀʏ
  • 105,112
  • 20
  • 162
  • 194
user3365654
  • 71
  • 1
  • 2

2 Answers2

2

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

Milica Medic Kiralj
  • 3,580
  • 31
  • 31
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.

Cᴏʀʏ
  • 105,112
  • 20
  • 162
  • 194