I am writing process to ship transaction log files from production SQL server to Read Only SQL Server. I am compressing transaction log in source DB, coping file to destination and restoring into Read Only instance. I do this in hourly bases. Restoring log file in Read Only instance takes too long. I wonder, if I use uncompressed transaction log, will restoring process faster?
Asked
Active
Viewed 30 times
0
-
Why wonder? Just try it. – SMor Aug 05 '21 at 11:35
-
Do not want to experiment in production environment, asking maybe someone already did and can share experience. – Otar Melia Aug 05 '21 at 13:41