Huge transactional log file

Huge transactional log file

  
ok we are experiencing a problem in our test server because the outsystems transactional log file is growing insanely, and by now is like 5GB in disk space.

so i was wondering if anyone could tell me if i could shrink and limit it to a smaller size?

i think i could use an sql command like DBCC SHRINKFILE or something like it but don't quite now how
i was having problems with this because i dind't have any space to do the backup, but when i did, it was pretty easy :P

DBCC SHRINKFILE(Outsystems_Log,500)

and done


(using sql server 2000)
hi,

you can always adjust the database recovery model to avoid that growth.

Best regards,