This is a new setup I'm trying to accomodate load.
I have server A that is production server. I have server B which is the exact same DB on server A that will be used only for reporting.
I have log shipping setup between server A and server B. Log shipping works ( I have DB B setup as standby/read only) - it works but if I run a query, then check my log shipping job I get the log shipping job error:
"Exclusive access could not be obtained because database is in use"
I need server B to be my report server, so I can't have it not complete the log shipping.
What can I do? I need server A and server B to be in sync and be 'reportable'..