WORKAROUND:
When restoring multiple transaction logs, if the database is to be in read only mode when the restore completes, restore the transaction logs using the NORECOVERY option. When all the logs have been applied, you can then switch the database to read-only mode. This incurs the cost of creating the undo log once, instead of every time that a transaction log is restored, and speeds up the overall restore process.
NORECOVERY leaves the database in recovery mode, which allows you apply further updates, and prevents anyone from accessing the database.
STANDBY also leaves the database in recovery mode, allows you to apply further updates, but allows users read only access to the database.
