July 10, 2012 at 7:56 am
Hello Masters,
Yesterday I configured log shipping for testing and today I checked the LSAlerts on secondary server which says that restore operation had not been restored from last 1055 minutes!!
How can I konw that which transaction log was last resotred ? Is there any query OR any DMV or any other way to know the last backup set that was resotred ?
Thanks in advance,
Jitendra
July 10, 2012 at 9:08 am
I again reconfigure log shipping for testing and found that restore job is failing, backup and copy job is working fine.
What could be the issue?
July 10, 2012 at 10:19 am
duplicate post - replies to http://www.sqlservercentral.com/Forums/Topic1327682-1549-1.aspx please
---------------------------------------------------------------------
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply