Oct 08 2022
My database log file has grown to 1TB. I have run the command
DBCC SHRINKFILE (Jack, 1); successfully
But the size of the drive is still full.
Please assist, i need drive space.
Oct 09 2022
@kwabekissi , that's to less on information.
In which recovery mode is the database; simple or full? If it's full, run a (or two) log backups.
Is there a replication setup? Or log shipping? What does
select name, recovery_model_desc, log_reuse_wait_desc
return for the database?