Log size is too large in my environment. Is it possible to create new transaction file every hour. Please tell me how to do it?
It sounds like you have your database in full recovery mode but are not backing up the logs independently. You can use SQL Agent to schedule a log backup once an hour, or, I'd say, even better, once every 15 minutes or so. This will remove completed transactions from the log, keeping the log from growing forever.
However, if you have log backups in place and you're saying the log is growing to very large proportions, then the problem is with the transactions that you're using. Solutions there will be very different.
One solution for my problem I found is alter database for splitting log files to some file size limit. We can also create file group.
No one has followed this question yet.