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.
