Whenever you perform a database creation, add a data or log file to database, AUTOGROW process is intiated or restore of database will trigger the file initialization if that is created afresh. In addition to this when you talk about files intialization
Read More...
Here is the script I have used to list the information regarding database objects such as tables, indexes and file groups along with their file names : ( extracted from Technet ) select 'table_name'=object_name(i.id) ,i.indid ,'index_name'=i.name ,i.groupid
Read More...