Results 1 to 4 of 4

Thread: datafile usage

  1. #1
    Join Date
    May 2004
    Posts
    10

    Unanswered: datafile usage

    If a database consists of more than one datafile, how does SQL Server use the space in these datafiles ?, does it fill up the first one then move to the next and so forth, or does it use up pages across all the files evenly ?.

  2. #2
    Join Date
    Mar 2004
    Posts
    114
    In a group, the files are all filled proportionnally to their size.

    For example : a group with file1 = 100 MB and file2 = 200 MB
    If you add 3 MB, 1 MB is added to file1, and 2 MB to file2.

  3. #3
    Join Date
    May 2004
    Posts
    10
    Thanks for the information

  4. #4
    Join Date
    Mar 2004
    Posts
    114
    You're welcome !

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •