restore tran log

hi;
under what situation will we call for these different actions:
1) restore tran-log (made since previous full bck) in sequence after lastest
back up is restored
2) restore only the latest tran-log (made since previous full bck) after
latest full bck up is restoredI do not think it's possible to just apply the latest transaction log, if
there had been other transaction log backups made since the last full
backup, unless the NO_TRUNCATE option was used. If this was the case, it
would be equivalent to performing a differential backup.
Regards
Ray
"pk" <pk@.> wrote in message news:OSa7NWWEEHA.3748@.TK2MSFTNGP11.phx.gbl...
> hi;
> under what situation will we call for these different actions:
> 1) restore tran-log (made since previous full bck) in sequence after
lastest
> back up is restored
> 2) restore only the latest tran-log (made since previous full bck) after
> latest full bck up is restored
>|||Ray is correct, you can not skip past restoring one tran log and then
restore a more recent log...SQL checks and requires that logs be restored in
the proper order..
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"pk" <pk@.> wrote in message news:OSa7NWWEEHA.3748@.TK2MSFTNGP11.phx.gbl...
> hi;
> under what situation will we call for these different actions:
> 1) restore tran-log (made since previous full bck) in sequence after
lastest
> back up is restored
> 2) restore only the latest tran-log (made since previous full bck) after
> latest full bck up is restored
>