CODEWITHSUNDEEP
sqlsql-serversql-server-2008filegroup
user3365654
user3365654

Reputation: 81

Adding file groups to database

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?

Upvotes: 2

Views: 2905

Answers (2)

Milica Medic Kiralj
Milica Medic Kiralj

Reputation: 3780

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

Upvotes: 4

Cᴏʀʏ
Cᴏʀʏ

Reputation: 107606

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

Upvotes: 1

Related Questions