Hi,
We have one database and we do lot many transactios per day, so the log file size growing too much, and i have tried shrinking it but its not reducing..
What shall i do to reduce the log file size. (We do too many inserts)
Thanks Srinivas
+2
A:
You have a database with "Full" recovery model and no log backups running.
Either set to simple recovery model or set up log backups. There are no other correct choices (such as shrinking or truncating). The link above has links to other articles too.
gbn
2010-06-29 11:59:01
I have changed the recovery model to Simple, and now how can i reduce the size of the db
Srinivas
2010-06-29 14:14:35
If you're in a production database with a "lot of transactions per day" I wouldn't recommend arbitrarily putting it into simple recovery. Make sure you know that you're putting your data at risk by doing so.
Mike M.
2010-06-29 23:09:18
@Mike M.: I assume OP had read the link and evaluated each in turn...
gbn
2010-06-30 05:42:07