I've set up log shipping using standby mode （The "Disconnect users in the database when restoring backups" is unchecked).
I tested running the following code on secondary server/database.
declare @a int while 1=1 begin select @a = count(*) from .... end
However, the code stops with the following error when log shipping restore job start to run.
Database cannot be opened. It is in the middle of a restore.
How to avoid the issue?