March 14, 2011 at 5:08 pm
Hi all,
Im doing a restore from of a db. but the situation is slightly strange. I want tomake sure that i have restored all the data so i have a couple of questions!
a: Full, Diff and Log backups have all been to one file! When i did a restore i ticked The Latest FULL db the Latest DIFF and the Latest Log would that get it back to the latest possible backups!
b: Does anyone know a way to check if a restore is up to date compared to the database it was backup from? ( Ive restored to a different server so im worried that doing the above didnt work as i intended so want a way to check if possible)
Any suggestions appreciated
March 14, 2011 at 5:47 pm
If you look through all the files, with a RESTORE HEADERONLY, you can check the for LSN (log sequence number). If you get to this highest one you have, you've gotten all you can from that file.
March 14, 2011 at 5:47 pm
Sorry, RESTORE HEADER ONLY: http://msdn.microsoft.com/en-us/library/aa238455%28v=sql.80%29.aspx
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply