Then how a user can query that standby mode database? Because log shipping says, users can query the database if we configure log shipping secondary in a standby mode.Please advice..

My requirement is to logship the primary database to a secondary instance on nightly basis and give access to user on secondary database in business hours to query that database. I mean the restore job on secondary will run from 7pm to 7am.

from the link http://msdn.microsoft.com/en-us/library/ms189970.aspx

Thanks