Please start any new threads on our new 
    site at https://forums.sqlteam.com.  We've got lots of great SQL Server
    experts to answer whatever question you can come up with.
    
        
            
                
                    
                        
                            
                                | Author | 
                                
                                 Topic  | 
                             
                            
                                    | 
                                         baselbj 
                                        Starting Member 
                                         
                                        
                                        3 Posts  | 
                                        
                                        
                                            
                                            
                                             Posted - 2008-02-29 : 03:39:52
                                            
  | 
                                             
                                            
                                            | i am not new to sql server but never think of how it work from the inside, but now i do :)what i need to know and discuss her is how sql server work with filegroups and file inside the filegroup.what i need to know exactly us that if i have multiple files within a file group how sql work and how object saved to this filegroup?will sql server save all object data at the same file in the file group or the object data will be saved in multiple files in the file group? | 
                                             
                                         
                                     | 
                             
       
                            
                       
                          
                            
                                    | 
                                     rmiao 
                                    Master Smack Fu Yak Hacker 
                                     
                                    
                                    7266 Posts  | 
                                    
                                      
                                        
                                          
                                           
                                            Posted - 2008-03-01 : 22:31:14
                                          
  | 
                                         
                                        
                                          | Sql will spread objects and data on all files in the failgroup.  | 
                                         
                                        
                                            | 
                                         
                                       
                                     | 
                                   
                            
                       
                          
                            
                                    | 
                                     baselbj 
                                    Starting Member 
                                     
                                    
                                    3 Posts  | 
                                    
                                      
                                        
                                          
                                           
                                            Posted - 2008-03-02 : 02:09:50
                                          
  | 
                                         
                                        
                                          | thank you  | 
                                         
                                        
                                            | 
                                         
                                       
                                     | 
                                   
                            
                            
                                | 
                                    
                                      
                                     
                                    
                                 | 
                             
                         
                     | 
                 
             
         |