January 31, 2011 at 11:13 pm
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
February 2, 2011 at 5:05 am
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®ards
Atcheswar reddy
February 2, 2011 at 5:44 am
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply