add data files into a primary filegroup in MS SQL Server

Question

When a database is created a file group with a data file is created by default. Is it possible to add more than data file into a primary file group.

Please, be more specific.

galloleonardo
– galloleonardo

2017-09-22 12:07:06 +00:00
Commented Sep 22, 2017 at 12:07 — galloleonardo
– galloleonardo, Commented Sep 22, 2017 at 12:07

Christian4145 · Accepted Answer · 2017-09-22 14:09:29Z

3

To add an data-file to primary filegroup:

USE [master]
GO
ALTER DATABASE [your_database] 
ADD FILE 
    (NAME = N'logical_name', 
    FILENAME = N'C:\my_data.mdf', -- <--Path to physical file
    SIZE = 1GB, 
    FILEGROWTH = 100MB
) 
TO FILEGROUP [PRIMARY]

answered Sep 22, 2017 at 14:09

Christian4145

5531 gold badge9 silver badges32 bronze badges

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

2 Comments

Sangram_2020 Over a year ago

I need to verify this

Christian4145 Over a year ago

You can add files to the filegroup "PRIMARY" the way you can add files to any other filegroup. You can delete these additional files again (when they are empty) like in any other filegroup. But you cannot delete the filegroup "PRIMARY". It is also not possible to rename it.

Collectives™ on Stack Overflow

add data files into a primary filegroup in MS SQL Server

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related