Adding files/filegroups to server - what's the best way?

[Maim]

I'm wondering if I'm going about this correctly...

I have a data file on the PRIMARY filegroup located on drive H: (100gb 1/0 etc...) The data file is getting close to 100gb so I had IT add another drive to the server.

What I want to do is stop the growth on the H: drive and start writing to the I: (new) drive.

Here's what I did;
DB Properties
Add new File with same Logical Name + "_1", kept the PRIMARY filegroup, initial size to 20gb, growth by 10% unrestricted on drive letter I:

I then went to the previous file and changed the max size to current size + 3gb.

Is this the best way to do this or can someone suggest a better (performance and maintenance) way of doing this?

Thanks in advance

-----------------------------------
"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rich Cook

 

[mrdenny]

Change the growth of the new file to 512 Megs. Never use % based growth.

You can simply disable the auto growth for the old file.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com