ADDING A FILE AND FILEGROUP TO THE EXISTING DATABASE

ADDING A FILE GROUP TO EXISTING DATABASE

ALTER DATABASE TEST_DB ADD FILEGROUP SECONDARY

SP_HELPFILE

ADDING A FILE TO FILEGROUP OF A DATABASE

ALTER DATABASE TEST_DB
  ADD FILE
  (NAME = N'DATA_2001',
  FILENAME = N'D:\BACKUP\TEST_DB.NDF',
  SIZE = 5MB,
  MAXSIZE = 100MB,
  FILEGROWTH = 5MB)
  TO FILEGROUP SECONDARY

CREATEING A TABLE UNDER THE FILEGROUP

CREATE TABLE TBL_SAL(NAME VARCHAR(50),SAL MONEY)ON FOURTH
DROP TABLE TBL_SAL

SELECT * FROM SYS.FILEGROUPS

SELECT NAME FROM SYS.DATABASES WHERE NAME= 'TEST_DB'