Share via

SQL Server 2012 files sizes, how to manage

John Lenz 1,726 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.
13,367 questions
0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 107.2K Reputation points
    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
  2. yunus emre ISIK 181 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
  3. ZoeHui-MSFT 35,556 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