Hi Friends, Is it possible to create a report on the secondary server configured for log shipping? Please let me know. Thank you, Joben
Check: http://stackoverflow.com/questions/1832848/is-it-possible-to-have-secondary-server-available-read-only-in-a-log-shipping-sce HTH
Yes its possible but during the TRANSACTION LOG RESTORE job on secondary server, all the connections must be cleared in order to complete. So until the restore is finished your reports will not be able to work/function.
