Transaction logs increasing rapidly.
We have 4 Exchange databases (Exch-2010 SP3) and observed that transaction logs are generating more on one of the database which causes disk space issue.
Can someone guide how we can identify the reason for increasing transaction logs for particular database.
Can someone guide how we can identify the reason for increasing transaction logs for particular database.
smangogna
You have to run a full backup to delete unecesary log files
ASKER
We have run full backup but my question is how we can identify the reason for generating huge no of transaction logs, is there any tool to find out.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Generally transaction logs will increase on a single database because the mailboxes on that database are making more changes than the other databases. This can be because there is more mail going to those users, or those users are sending more mail, or there are a lot of large attachments on those mailboxes. In general, the only thing that causes transaction log growth is an increase in the number of transactions. If one database is generating more logs than the others, you can try to distribute some of the users on that database to other databases. Other than that, there really isn't much you could do about it. Transaction logs record everything that every user does in Exchange, so you just have to deal with it if one database records more logs or balance the users across your databases more efficiently.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.