SQL Transaction log

Customer Support H-Sphere Reseller Hosting
1

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

2

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.

3

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.