Reducing local SQL Server DBs Disk space usage

First, you can check its Disk usage at:
right click on database > Reports > Disk usage.
Which also tells you how much space is used by data and how much for logging.

1. Remove full logging
Right click on db > Properties > Options > Recovery model > Set to “Simple”.

2. Clean up the database
Right click on db > Tasks > Shrink > Database > Ok

Now you can refresh the report and check how the log data is mostly gone. Shrinking the database also reduces the amount of space data uses a bit.

Leave a Reply

Your email address will not be published. Required fields are marked *