SQL Transaction log

[indian]

I recently faced a problem wiht a SQL DB

the DB size is about 200 MB and set in the ratio : 10%/90% - DB/LOG

But the Log file SIZE seems to get ERRATIC and keeps on increasing.

how to stop this ?

Indian

 

[Stephen]

You can't stop the SQL log, it is vital to having your database, you need to make the DB size smaller overall, maybe do a cleanup.

 

[Typ0]

are you doing a lot of inserts and deletes? If you are removing large numbers of records using delete try using truncate and bulk insert instead. back up your database more often.