Link to home
Start Free TrialLog in
Avatar of bjennings
bjennings

asked on

SQL Server 2008 – moving default directory paths to different Drive.

Hello Everyone,

I am running a sql server 2008 which has the default directories pointing to the D:\ drive.  I need to move everything over to the E:\.  I moved all my databases and system databases from D:\ to E:\ without any issues.  I am seeing the following registry keys pointing directories to the D:\ drive

HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10.MSSQLSERVER\CPE
ErrorDumpDir  REG_SZ   D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\LOG\

HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQLServer
BackupDirectory REG_SZ  D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSQL\Backup

HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10.MSSQLSERVER\Setup
FullTextDefaultPath REG_SZ   D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\FTData
SQLDataRoot  REG_SZ   D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL

HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10.MSSQLSERVER\SQLServerAgent
WorkingDirectory REG_SZ  D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\JOBS

Can I just change these registry keys to point to the E:\?

Thanks,

Bill
ASKER CERTIFIED SOLUTION
Avatar of Vikas Garg
Vikas Garg
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
You can change the paths and this should not cause any issues.  What I have done in the past was shutdown the services, move the desired directories to the new drive and then change the drive letter (i.e. swap them) in Computer Management under disk management.
Avatar of bjennings
bjennings

ASKER

Thank you to both of you!