how to check whether it is getting updated from primary to secondary database which is in norecovery

Posted by Yrajudba under Sql Server on 10/15/2011 | Points: 10 | Views : 889 | Status : [Member] | Replies : 1
HI,

I have configured a DR setup to my client using logshipping and we restored it in secondary server with norecovery option, so we cannot access the database, it will be in restoring...
how to check whether it is getting updated from primary to secondary database which is in norecovery . Even I check the timestamp and db size, there is no change but the jobs are successful.

Please give a solution how to check...

Thanks
Raju




Responses

Posted by: Sriramnandha on: 10/27/2011 [Member] Starter | Points: 25

Up
0
Down
open Query Analyzer check log shipping runtime..

Regards
Sriram.R

sriram

Yrajudba, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response