Sample Header Ad - 728x90

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