reorder size of secondary data files?

Hello,
I have a database which secondary files are splitted into
4 pieces. Each Piece on a severall harddisk (18GB).
Now i have the following situation:
file1(.ndf)=5GB
file2(.ndf)=11GB
file3(.ndf)=17GB
file4(.ndf)=7GB
Is there a possibility to balance the filesize?
The harddisk for file3 is at the limit and doesn't spend
any performance!!!
10GB for Each file and a balanced growth would be nice!!!
Thanks a lot
CharibertYou can shrink the bigger files so that data from it gets "pushed" over to the smaller file (I
suggest you pre-increase the size of the smaller files before this).
Above is only way I can think of, unless you want to go through unload/import route.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Charibert Greif" <Greif@.gob.de> wrote in message news:44f401c376af$0ebe9030$a301280a@.phx.gbl...
> Hello,
> I have a database which secondary files are splitted into
> 4 pieces. Each Piece on a severall harddisk (18GB).
> Now i have the following situation:
> file1(.ndf)=5GB
> file2(.ndf)=11GB
> file3(.ndf)=17GB
> file4(.ndf)=7GB
> Is there a possibility to balance the filesize?
> The harddisk for file3 is at the limit and doesn't spend
> any performance!!!
> 10GB for Each file and a balanced growth would be nice!!!
> Thanks a lot
> Charibert|||Have you tried DBCC SHRINKFILE
For more details please refer to BOL
"Charibert Greif" <Greif@.gob.de> wrote in message
news:44f401c376af$0ebe9030$a301280a@.phx.gbl...
> Hello,
> I have a database which secondary files are splitted into
> 4 pieces. Each Piece on a severall harddisk (18GB).
> Now i have the following situation:
> file1(.ndf)=5GB
> file2(.ndf)=11GB
> file3(.ndf)=17GB
> file4(.ndf)=7GB
> Is there a possibility to balance the filesize?
> The harddisk for file3 is at the limit and doesn't spend
> any performance!!!
> 10GB for Each file and a balanced growth would be nice!!!
> Thanks a lot
> Charibert|||Hello,
I have noticed that SQL server tries to automatically
balance infill of the files in filegroup.
Recently I've added one file to each filegroup in
my DB but existed files weren't filled completely and
now I see that server insert new data into the new
files only and execution of INDEXDEFRAG is actively
moving data into new files!
So, in your case, it may be useful to increase size of
some files, run some reorganisation work (rebuilding
indexes is the best way), and later shrink files which
will get free space.
> I have a database which secondary files are splitted into
> 4 pieces. Each Piece on a severall harddisk (18GB).
> Now i have the following situation:
> file1(.ndf)=5GB
> file2(.ndf)=11GB
> file3(.ndf)=17GB
> file4(.ndf)=7GB
> Is there a possibility to balance the filesize?
> The harddisk for file3 is at the limit and doesn't spend
> any performance!!!
> 10GB for Each file and a balanced growth would be nice!!!
Serge Shakhov