How to reduce a DB size

Question

Hi,
I have an alarm of only 19% of free space
I have a 655.000 mb size db, how to free space on it?
thnk

Shweta Lodha · Accepted Answer

You can make it compact by running Shrink Database.

Nirmal Dayal · Answer

Remove the transactional data from tables only keep only master data. Other wise see article https://docs.microsoft.com/en-us/sql/relational-databases/databases/shrink-a-database?view=sql-server-ver15

Mahesh Chand · Answer

In addition to what is already mentioned above:   Log file is one of the biggest space hogs. Depending on what is your default setting is for log file but you can change that to log on a week or two logs. You can also cleanup the database. Take a backup and any data that is not being used or will not be used, you can delete that.

Ramón Miguel Quintana Rosa · Answer

DONE!!
FROM SSMS RUN:
Shrink Database task.
and u got it...