Forum Discussion

kwabekissi's avatar
kwabekissi
Copper Contributor
Oct 08, 2022

Transaction log

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.

  • olafhelper's avatar
    olafhelper
    Bronze Contributor
    Oct 10, 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
from sys.databases

    return for the database?

     

    Olaf

Resources