Sign in with
Sign up | Sign in
Your question

SQL server hard drive size

Tags:
  • Business Computing
  • SQL Server
  • Hard Drives
  • Servers
Last response: in Business Computing
Share
October 10, 2014 5:59:18 AM

I have a SQL server running on server 2008 R2. I was doing routine checks on the servers and noticed the C:\ drive is about 90% full out of 300 GB there is about 28 GB free. I installed windirstat to see what was using up so much space. My first thought was some SQL logs or some other logs grew way to big. But when I ran windirstat and selected the C drive after the scan it said only about 65 GBs were being used on the C drive. I went back into My Computer but the C drive is still showing almost full. I ran windirstat again same results. I manually started right clicking on the files under the C directory and the sizes were close to the ones from windirstat. How can I correct the C drive in My Computer to show the correct amount,without having to reboot the server.

More about : sql server hard drive size

October 10, 2014 8:41:27 AM

Locations such as "System Volume Information" are owned by system and are not listable by users, even with admin rights, and will always return 0 for size. A large chunk of what's in use may be restore points.
m
0
l
October 13, 2014 5:48:11 AM

I can't find anywhere to see a list of restore points, like I can in 7. Plus does server 2008 R2 even have restore points?
m
0
l
!