Default filegroup is the one in which all database files are created when created without specifying a filegroup, all books say.
I did this
CREATE DATABASE Akshay_DB
ALTER DATABASE Akshay_DB
ADD FILEGROUP Secondary_FG
ALTER DATABASE Akshay_DB
ADD FILE
(
NAME = NonClust,
FILENAME = 'E:\fileone.ndf',
SIZE = 5MB,
MAXSIZE = 100MB,
FILEGROWTH = 5MB
)
ON FILEGROUP Secondary_FG
MODIFY FILEGROUP Secondary_FG
DEFAULT
ALTER DATABASE Akshay_DB
ADD FILE
(
NAME = NonClust,
FILENAME = 'E:\filetwo.ndf',
SIZE = 5MB,
MAXSIZE = 100MB,
FILEGROWTH = 5MB
)
filetwo is created on primary even when Secondary_FG is the default
Why is it so ?