Restore Question

Hello,
I'm testing restoring a db with 5 tlogs using the norecovery option until
the last tlog. During testing I happened to restore the logs out of order,
but did not receive an error message during the out of order log restore. Is
this normal? I would think restoring logs out of sequence would generate an
error.
Any help appreciated!
Thanks in advance.Yes, it should generate an error. Perhaps you did zero modifications between the log backups? In
that pretty special case, there would be now log records to roll forward, and I believe that SQL
Server would because of that not complain about out-of-sequence (since there isn't anything to
sequence over).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Mark" <Mark@.discussions.microsoft.com> wrote in message
news:D82E2BC4-BF82-4E46-8D01-9E4B8AD92220@.microsoft.com...
> Hello,
> I'm testing restoring a db with 5 tlogs using the norecovery option until
> the last tlog. During testing I happened to restore the logs out of order,
> but did not receive an error message during the out of order log restore. Is
> this normal? I would think restoring logs out of sequence would generate an
> error.
> Any help appreciated!
> Thanks in advance.