Is there any way to relocate the data and log folders?

Is there anyway to move the data and log folders to another drive without having to reinstall SQL 2005. I have limited space available on the drive where the program files are installed and need to move these folders to another drive with adequate space for growth. Thanks

If you have to just move the standard folder (where new databases are created) you can do it through the GUI (just have a look at the server properties of the server). If you don′t have a GUI because you are using Express you can tweak the registry:

http://groups.google.de/group/microsoft.public.sqlserver.server/browse_frm/thread/c04546243a680213

If you want to move the database files which are already exsiting, you can move the files with the ALTER DATABASE command.

Sorry, for the multiple options, but you didn′t specify your problem / concern in detail :-)

HTH, Jens Suessmeyer.

|||

Jens,

Thanks for the quick response and sorry for not providing more detail. Basically I would like to relocate the MSSQL folder under the Program Files\MSSQL.1 folder to another drive that will accomodate the growth of these files. I have already moved the mdf and log files for the database files using the GUI. Thanks again.

|||So your problem is solved, right ?|||Yes, Thanks|||

So, it would be nice if you could track it with "solved" in the group system.

Cheers, jens.