ADSM-L

Problem with restoring a SQL Database

2015-10-04 17:40:33
Subject: Problem with restoring a SQL Database
From: Miguel Demaerel [mailto:Miguel.Demaerel AT SGMS.SEMA DOT BE]
To: ADSM-L AT VM.MARIST DOT EDU
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

                   ////
                  (o o)
==============oOO==(_)==OOo==============
             Miguel DEMAEREL
        Sema Group Managed Services
       Raketstraat 98 - 1130 Brussel
                 Belgium
       Tel: +32 (0)2 724 93 17
       Fax: +32 (0)2 724 92 92
 EMail: Miguel.Demaerel AT SGMS.SEMA DOT BE
=========================================
<Prev in Thread] Current Thread [Next in Thread>