When you restore a transaction log to another instance of a database (another server, another name, another instance of SQL Server), it doesn't actually restore any completed transactions, just restores the file.
That's one of the reasons I recommend a log parsing application. Those can read from the backup.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon