Redirect SQL 2005 data & log files to another partition

When SQL Server 2005 was originally installed by previous IT guy he accepted
all defaults for location of files. Now all new databases and logs will be
created on C: instead of D: and C: is System partition and does not have
enough space for databases and logs. How do I tell SQL to redirect all new
dbs and logs to D I can't find anything in kb or books online about
redirecting after installation. I can find only articles on moving dbs for
disk failures etc. Where is there documentation on redirecting for future
databases and logs? Thanks!

Steve,

In SQL Server Management Studio, right click on server name and choose
Properties. The Database Settings tab has the entries for the default
database and log locations. This will affect future database creation.

If you are curious, these values are not stored in the database, but in the
registry. E.g.

USE [master]
GO
EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE',
N'Software\Microsoft\MSSQLServer\MSSQLServer', N'DefaultData', REG_SZ,
N'D:\DATA'
GO
EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE',
N'Software\Microsoft\MSSQLServer\MSSQLServer', N'DefaultLog', REG_SZ,
N'D:\LOG'
GO

RLF

"Steve Ikard" wrote in message

> When SQL Server 2005 was originally installed by previous IT guy he
> accepted
> all defaults for location of files. Now all new databases and logs will
> be
> created on C: instead of D: and C: is System partition and does not have
> enough space for databases and logs. How do I tell SQL to redirect all
> new
> dbs and logs to D I can't find anything in kb or books online about
> redirecting after installation. I can find only articles on moving dbs
> for
> disk failures etc. Where is there documentation on redirecting for future
> databases and logs? Thanks!