Transaction log

Occasional Visitor

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.

1 Reply

@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