Hi

• sj1918-public

  Newbie

  Points: 3

  More actions

  January 31, 2011 at 11:13 pm

  #244509

  Environment - SQL server 2005 with sp 2. 'Database1' is in norecovery mode. When i look into the folder where backup job writes back ups to, i can see that there is a full back up and 100s of log backups. i want to know upto which log file the restore worked fine. The restore job is failing now and i assume it woked fine upto 50 logs and then started failing. How do I know about the last log back up file that was restored? which system objects to query? I dont have records on restorehistory. Any help provided will be appreciated

• atchimule

  SSC Journeyman

  Points: 91

  More actions

  February 2, 2011 at 5:05 am

  #1281373

  Hi,

  every t-log backup has his own Lsn no. ..basd on Lsn no you will find which was the last restore File...

  If any Wrong please forgive.....

  Thanks&regards

  Atcheswar reddy

• M&M

  SSC-Insane

  Points: 21700

  More actions

  February 2, 2011 at 5:44 am

  #1281383

  You can refer to the 2 links below which would help you to understand which system objects to query in msdb.

  http://www.mssqltips.com/tip.asp?tip=1724

  http://www.mssqltips.com/tip.asp?tip=1860

  M&M