SQL Server 2012 files sizes, how to manage

John Lenz 1,716 Reputation points
2023-07-17T16:33:43.69+00:00

Hyper-V server 2102R2

SQLserver2012

My VHDX is 156GB, I have only 9 GB left.

How do I manage size, I cannot keep upping VHDX space.

This is a very small home consulting business (2 users). The data bases I have are, SharePoint, WSUS and NovaStor CMON. I do not keep a lot of data here (except for whatever WUS stores).

I did limit number of archives to 6/.

Also, I have created scheduled jobs in each DB to shrink log files.

I ran a file explorer search for *.ldf and all files are very small.

What can I look to, to manage the size?

Thanks

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,322 questions
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. Erland Sommarskog 99,371 Reputation points MVP
    2023-07-17T16:46:08.05+00:00

    Shrinking files is pointless if they grow again. Shrinking is an operation you only do in exceptional cases, like when a file exploded due to some mishap.

    156 GB is not a lot of space, so staying with that limit will be a tough came.

    When I'm running low on disk space somewhere, I usually rely on TreeSize Free from Jam Software to find out where the space goes on disk level.

    0 comments No comments

  2. yunus emre ISIK 171 Reputation points
    2023-07-18T04:46:19.59+00:00

    If the server taking backups. you can check and delete old backups also

    0 comments No comments

  3. ZoeHui-MSFT 30,881 Reputation points
    2023-07-18T06:28:22.9833333+00:00

    Hi @John Lenz,

    I ran a file explorer search for *.ldf and all files are very small.

    It seems the low disk space is not related with SQL Server.

    Check this to see if it could help free up drive space on your PC.

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments No comments