homebrew01 (1/6/2010)
laddu4700 (1/6/2010)
Restore full backup with no recoveryrestore diff backup with no recovery
restore diff 2 backup with recovery
You only need to restore the most recent diff, then all the transaction logs more recent than the diff.
Yes - as homebrew said. Eliminate the middle diff backup and then add your tran logs more recent than the last diff.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events