Home Forums SQL Server 2005 Administering restore database RE: restore database
homebrew01
SSC Guru
Points: 55539
More actions
January 6, 2010 at 11:37 am
#1099807
laddu4700 (1/6/2010)Restore full backup with no recoveryrestore diff backup with no recoveryrestore diff 2 backup with recovery
laddu4700 (1/6/2010)
restore 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.