Problem with restoring a SQL Database
2015-10-04 17:40:33
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
=========================================
|
|
|