Move database to 2nd hard drive?

[ihaveaproblem]

Hi

 

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?

 

Thanks.

[timbo343]

Surely you can just dismount the database in SQL management studio, move the database folder to the D: and then remount the database when all has been moved across.

[ihaveaproblem]

Surely you can just dismount the database in SQL management studio, move the database folder to the D: and then remount the database when all has been moved across.

 

I dont know can I ?

Sorry, really not clued up on sql ! I'll have a look and see if I can do your suggestion.

 

EDIT

 

That worked fine timbo.

Thanks very much.

So easy when you know how

Edited June 26, 2012 by ihaveaproblem