title: Restored database taking massive amount of space
body: <p>I restored a database with a 1.5gb .bak file. Everything works fine except the restored database now takes 64gb of space.</p>
  
  <p>I've heard about shrinking databases and log files but how should I find out what is it that takes so much space and what I can "shrink" so that the data itself won't change. I need this production backup data in my development environment as it is.</p>
  
  <p>I don't need full logs in the development environment where I'm doing the restoring. How to find out is it the data or the logs that take more space?</p>
  
  <p>I'm using SQL Server Management Studio 2017</p>