[Q] Why is the KAL_AUTH_Log.LDF file so large?

my KAL_AUTH_Log.LDF file is 4giga after 1 week
how i can make it small without losing data?

at's server was 104 GB its just backups.. incase you get hacked..

new acc?

write the following in query analyzer from the mssql server and execute it till Transactionlog (the file you mean :) ) is at you favourite size or less
after that go in enterprise manager and set maximum size to whatever you want

Code:

---

backup log KAL_DB with truncate_only
DBCC SHRINKFILE(KAL_DB_Log,10, TRUNCATEONLY)

---

PS: our was 10.6 GB ;)
PS2: Its a transactionlog, NOT a backup !