dakshinamurthy (12/31/2008)

---

Hi,

How to make log-shipped database to be available for queries.

I have MyDB in one Server which is used for Log-shipping and in the other Server MyDB is getting Logshipped. Now how do i cross check the DML Operations done in MyServer for MYDB is also been made in the other Server which is getting log-shipped.

In the sence can i execute a Select Statement to the logshipped DB in the other Server, even still my DB in My Server is active.

With Regards

Dakshin