Miguel,

If Nathan's suggestion does not work for you
(about SQL Server 6.5 SP5a being the problem)...

...is it possible that you were using "no truncate"
on the transaction log backups?  In that case,
your second transaction log backup will contain the
same log entries as your first and therefore produce
the message you were seeing.

Thanks,

Del

----------------------------------------------------
Del Hoobler
Del Hoobler
IBM ADSM Agent Development
hoobler AT us.ibm DOT com

|| I have also had problems with restoring SQL 6.5 databases, before we went to
||SQL 7.  What I found was that the problem was caused by SP5a.  I rolled back
||to SP4, and everything was fine.  It really gave us incentive to migrate to
||SQL7!
||
||I would really look at the SP5a as being your problem.
||
||Nathan J. Norrgard

> Hoi All
>
> SQL Agent Version 1 release 1 level 1A.
> ADSM Server Version 3 Release 1 Level 2.22 (AIX)
> SQL Server version 6.5 SP 5a
>
> I'm testing the SQL connect agent.
> I'm SA and SA is the database owner. (SA is the system administrator on SQL
> level)
> I'm backup and restore with the SA account.
> This is the test senario. (The backup and restore is done with the GUI
> interface)
> I added 2 records, take a full backup (no truncate).
> Add 1 record, take a incremental backup
> Add 1 record, take a incremental backup
> Take a full backup with truncate.
> Restore full backup 1: OK
> Restore full + first incremental backup: OK
> Restore full + first incremental backup + second incremental backup: NOT OK
>         Error msg: the incremental backup is out of sequence (thats not
possible!!)
>         The second incremental backup is always out of sequence.
> Restore second full: OK
> There is nothing special on this database (2 tables, 2 primary indexes and a
> link between the both).
> I have test it also with the SQL tools and everthing was ok, no problem to
> restore the full and 2 incremental backups.
>
> I have tested it several times.
> To restore a full backup no problem, but incrementals ....
>
> Can someone help me with this?
> Do I something wrong?
> Is there a fix for this problem?
>
> Thanks in advance.
>
> Greetings Miguel