I’m in a new situation where we are running transaction logging, great. The logs are created fine, and backed up fine. Our problem is when we need to do a restore, for example a restore might need 200 transaction logs restored… What we find is that the process of restoring these logs to the log directory causes a major performance impact to the running of the live server?
The logs are on separate disks etc, as reccomended. Any thoughts or pointers greatly appreciated! In ideal world I’m thinking of being able to restore the logs and replay them from a separate drive???
Subject: Restoring Transaction Logs Affects Performance - Any thoughts?
Only that if possible, you restore the logs to yet a third (and different) disk. You can use an ini param that conrtols where the logs are restored.Straight off of one of my boxes:
TRANSLOG_RECOVER_PATH=F:\Recoverlogs
This way you are not competing for disk i/o on the translogging drives.