file growth on seperate partition

[Former Member]

Hi All,

I am new on SQL server 2005 env.I have installed sql 2005 on win 2003 and SAP ECC.I have one .mdf file , three .ndf file and a log file.Now since one of my partition which is holding .mdf file is almost running short of space.I want that the growth should happen in other partition(new one).how can I achieve that?

Thanks in advance for the help

Regards,

Ravi

[Former Member]

Dear Sven,

I am facing the same issue here.

Can u guide me How do i migrate the database and log file instead of stoping the going for new file.

Thanks in advance..

Rgds,

vadivu

[Rudi_Wiesmayr]

This will need some downtime, as you will have to stop everything using the DB,

detach the files, move them and reattach them.

For details see DETACH and ATTACH in books online.

HTH, Rudi

[Former Member]

Hi Ravi,

just disable the "Autogrowth" function for the .mdf-file and set the "Maximun File Size" to a static value. Then add another .ndf-file. You can use the Management Studio to do so. You find these features in the properties of your database (see note 363018).

Regards,

Sven