how to find the file in user define filegroup

• rajeshsdba

  SSC Veteran

  Points: 210

  More actions

  April 17, 2013 at 1:44 am

  #292286

  Hi ,

  when i used

  alter database MYDB addd file

  (name ='mydb_1',

  filename='c:ew\mydb_1.ndf,

  size=10mb,

  maxsize=200mb,

  filegrowth=10 mb) to filegroup FG1

  then file showing in FG1

  but when we add the another file then file going in primary filegroupe. I have already default filegroup assinged FG1.

  Rajesh Singh
  DBA(HCL Comnet)
  +91-0560888360