It came to my attention last week while planning a CRM SBE installation that we needed to place the CRM databases on a on the D: drive, instead of the current SQL configuration of C:.

After a bit of Googling, I discovered this is actually fairly easy, using the following procedure:

1) Start SQL Server Enterprise Manager.

2) Right-click on the SQL Server name.

3) Select Properties

4) When the SQL Server properties dialog displays, click on the Database Settings tab, as shown below:

5) Change the Default data directory and Default log directory to the new location on the new drive.

6) Click ok.

7) This information is stored in the Windows Registry and just to make sure that everything was set correctly, I stopped and restarted the SQL Server service.