- Phil has created a new database that takes advantage of multiple physical disks on his server. He has created his primary data file on one disk and placed a secondary data file on a separate physical disk. The transaction log exists on the same physical disk as the primary file. Phil’s plan is to put all user objects on the secondary data file and leave the system tables on the primary data file. After creating all his objects, however, he quickly discovers that they ended up on the primary file group. What might he have done wrong?
   He probably forgot to create the secondary data file as part of a separate file group. Objects are created on file groups rather than on data files.