All geek questions in one place

SQL Server File and Filegroup

I cannot think of any reason why we need to have multiple files inside a group of files. The reason I think about this is because we can control the T-SQL level (end user) about a group of files, but we cannot control the T-SQL level (end user) about individual files in a group of files. Any comments or ideas why the files are still needed?

thanks in advance George

+3
source share
3 answers

Having multiple files per file group is only useful for the following reasons:

  • - . , RAID , RAID.
  • , VLDB , .

" ", SQL Server 1 , . , , , Microsoft.

. SQL Server 4.2 7 sql FAT32, 4 . ( , ) - DBs 4 FAT.

+4

, , : Windows FAT32 2 . , ( MS Access-Database). , (: 2 ), . , , . . , , , tabledata. , , , . "" maxize (: 2 ), . , "" ( , , (, 1 ) , RAID. . ). , , http://msdn.microsoft.com/en-us/library/ms188730%28v=sql.105%29.aspx. , " R:", " S:", . , .

+2

I could provide a long explanation, but MSDN does a good job of this here . You may not need to have more than one file in a group of files, but this does not apply to all.

+1
source

Source: https://habr.com/ru/post/1703658/

More articles:


All Articles