May 14, 2015 at 6:00 am
Hi,
In my environment log shipping is set and tuf the file size is 9 mb.but it is restoring it is taking 2hrs time.
what is possible reason
Thanks,
May 27, 2015 at 8:47 am
A few questions:
1. Ballpark how many transaction log backups are you restoring to get your database up to date?
2. How big are these transaction log backup files?
3. When each individual transaction log backup restored are you using the READ ONLY recovery option with the tuf file?
If the answer to point 1 is more than 1, and the answer to point 3 is yes, then this is the reason your restore takes so long, as when restoring the log backup with the READ ONLY recovery option it requires the creation of the tuf file so that it can be returned to a no recovery state when the next transaction log backup is restored. If you have lots of files (like we do) you only want to recover the database to read only when the last transaction log backup in your set is restored.
MCITP SQL 2005, MCSA SQL 2012
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply