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.

Answer 1

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]