Oct 08 2022 03:12 PM
Hi Team,
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 10:30 PM
@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
from sys.databases
return for the database?
Olaf