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.


2 Answers 2


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.

Right click on your database and select properties. In the file tab you find your database .mdf and .ndf files path. You can use detach and attach to move your files. Also you can modify new filegroup and add objects to that filegroup to have additional space.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.