If you have large MSSQL database then you can shrink it to free up some space on SQL server. This shrinking process will remove the unused space from database.
You can follow below steps to shrink database via Microsoft SQL Management Studio
You can follow below steps to shrink database via Microsoft SQL Management Studio
- Login to your SQL server.
- Now expand databases and choose your particular database.
- Right click on database and navigate to shrink >> Tasks >> Shrink >> Database.
- At last, click on “OK” button.