We have a SQL Server Express instance, where one database reached 10Gb.
We have deleted 90% of the larger db table records, supposedly clearing 4Gb of space, according to allocation_units.used_pages.
DBCC SHRINKFILE has reduced the log file, but hasn't affected data file size.
The database recovery model is simple.
DBCC SHRINKFILE (datafile, TRUNCATEONLY);
DBCC SHRINKFILE (logfile, TRUNCATEONLY);
Are there any restrictions of DBCC SHRINKFILE on SQL Server Express edition?