Transaction log too big

D

David

The Project Server transaction log has increased in size
to 24GB without much users using it. The data file is only
500MB. I was unable to access the database as there was no
disk space available. On doing a Transaction log backup it
has reduced in size to 22GB. Now the database is up &
running.
What should be done to the Transaction log to reduce the
size?

Regards,
David.
 
O

OK

I had the same
You should shrink the DB
If you don't use transactional log, change it to simple, now it's FULL
Read SQL Server Book Online
 
Top