Can you change root directory of sqlServer 2005

hamilton · April 3rd, 2007, 10:47 AM

Hi there,

I need to change the root directory path of a SQL Server 2005 installation.

Is it possible to manually change the root directory after installation or do I need to re install it?

Thanks you for you help
H

Peso · April 3rd, 2007, 12:54 PM

First obvious question is

"WHY?"

hamilton · April 4th, 2007, 03:26 AM

Would like to point the root directory to a larger disc partition

Peso · April 4th, 2007, 03:58 AM

SQL Server files only occupies about 1 GB of space.
You can put USER DATABASES on any partition you want, as far as SQL Server service concerns.

Is this what your problem really is? You are out of space for databases?

hamilton · April 4th, 2007, 04:07 AM

I have been asked at work if I could change the root directory to another partition in order to prevent us from running out of space in the future.
I was hoping i could change the root path without having to reinstall sql server.

Thanks for you help

hamilton · April 4th, 2007, 05:46 AM

Got it sorted thanks.

Just detached the database copied files across to new directory and reattached database.

http://support.microsoft.com/kb/224071

Cheers