CODEWITHSUNDEEP
sql-servertransaction-loglog-shipping
Otar Melia
Otar Melia

Reputation: 1

Is uncompressed transaction log file restore process faster then compressed in SQL SERVER

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?

Upvotes: 0

Views: 36

Answers (0)

Related Questions