Re: Adding New Disk

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 06/23/04 

Date: Wed, 23 Jun 2004 11:55:04 -0400

Files within a file group get filled in a proportion fill method that is
based of the amount of free space in the file. So if you added another file
some new data would be inserted into the existing one(s) but most would go
into the new one. At least until they leveled off. If your concerned it
would be best to BCP out all the data, truncate the tables, add the new
file(s) and then BCP the data back in. That would fill them more evenly and
place more of the existing data on the new files. 

-- 
Andrew J. Kelly  SQL MVP
"Brad" <me@privacy.net> wrote in message
news:MPG.1b435bcab46a01ee98bdd7@news...
> When I add a new disk and put a file on it and make it part of the primary
> filegroup, how does disk space get used?  Basically my current disk is 90%
> full and I'd like to relieve it as much as possible.

Relevant Pages

  • Re: How to know the disks space during a process?
    ... You could use a tool to monitor disk space and alert, ... I need to know the free space in disks by doing this test. ... The batch file will log the amount of free space on C: ...
    (microsoft.public.windows.server.general)
  • Re: free disk capacity?
    ... the amount of occupied disk space has almost no effect on the speed at which your computer performs. ... A hard disk would need to be virtually filled in order affect your computer's performance, and with 6GB you have plenty of free space. ... (dllcache, recent, prefetch, temp, %temp% and files in internet properties) ...
    (microsoft.public.windowsxp.general)
  • Amount of free space in a bound volume set?
    ... Does anyone have a code example (DCL or C) for determining ... Is a disk a bound volume set? ... What is the amount of free space on the bound volume set? ...
    (comp.os.vms)
  • Re: Drive mapping disk size isnt right
    ... Ray Joslyn wrote: ... > share, it does not display the right size of the disk, nor the right ... > amount of free space. ...
    (microsoft.public.windows.server.networking)
  • Re: FAT32 or NTFS?
    ... >>10% wastage on 10 volumes is one whole hard disk wasted. ... >uncertainty about free space. ... Corrupt data can be better than none, ... "you can only recover part of the database". ...
    (microsoft.public.windowsxp.general)
Quantcast