Free some space on a full Express Edition instance
3
votes
2
answers
1430
views
Using Microsoft SQL Server 2016 (RTM) - 13.0.1601.5 (X64) Express Edition (64-bit)
I have a database that reaches the maximum space (10Gb) every month.
In order to free up some space I do a bacpac, create a new database with the bacpac and shrink it 2 times.
The database goes from 10Gb to 6Gb, and the application using this database gets faster (I think the bacpac refreshes the indexes).
Is there a SQL command to do this? Can I do this in a production database?
Asked by Pedro Adão
(33 rep)
May 14, 2021, 10:58 AM
Last activity: May 21, 2021, 11:58 AM
Last activity: May 21, 2021, 11:58 AM