How to set up where to store data in SQL Server My C:\ drive has a size of 99GB and my D:\ drive has a size of 2TB

Here comes the problem: where does SQL Server store data in the database? Can I control it?

Actually, my C:\ has been full of data now..... and I don't know how to deal with it.

I want to configure SQL Server right so that I can store data on D:\

Thank you very much.
You could also control it with:


detaching the database in SQL management studio
move the *.mdf and *.ldf file to the location you desire (C:/ or D:/)
reattaching the database by selecting the new path.