Dont know a great deal about sql.
Have a new server running server 2008 R2 with Microsoft sql 2008 R2 installed.
The server has two hard drives which appear as C: and D: in Windows.
I want all the databases to be stored on D:, so they are away from the system OS + the D: drive is large in size which I think will be helpful as the databases grow.
So my question is. How do I configure sql so the databases are stored on the D: drive?