I have a database which is 400GB, I've deleted many tables in it and ran the following query many times but the size still remains pretty much the same.
USE [Tables Backup]
DBCC SHRINKFILE([Tables Backup_Log], 1)
BACKUP LOG [Tables Backup] WITH TRUNCATE_ONLY
DBCC SHRINKDATABASE ([Tables Backup], TRUNCATEONLY);
Did I miss out some steps? Thanks