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.

 All Forums
 SQL Server 2005 Forums
 .NET Inside SQL Server (2005)
 sql server filegroups and files

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.
Go to Top of Page

baselbj
Starting Member

3 Posts

Posted - 2008-03-02 : 02:09:50
thank you
Go to Top of Page
   

- Advertisement -