Recovering data from tran logs when no full is available

[RRinTetons]

For reasons I prefer not to discuss,I have transaction log backups for which I don't have a full backup for integration. The tran logs contain data that it might be helpful in a recovery challenge I face. Is there any way to extract data from those tran logs?

-
Richard Ray
Jackson Hole Mountain Resort

 

[mrdenny]

Not without the full backup. With enough time and a hex editor you might be able to make it work, but it'll be a hell of a lot of work and it'll take a consultant with a LOT of knowledge of the SQL Server backup internals. You'll also need to have all the transaction logs.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)
MCM (SQL 2008)
MVP

My Site