Restore of backup fails, backup file corrupt?

We made a backup of one of our databases. The backup was done to disk. Fir
st a full backup and then differentials. When we try to restore this backup
we run into problems... The restore of the full backup works without probl
ems, the first differential
(#2 in the backup set) can also be restored without problems. But when we t
ry to restore one of the other sets (3 -> 31) we get the following errors:
"Server: Msg 3136, Level 16, State 1, Line 1
Cannot apply the backup on device 'e:\voyager.bak' to database 'Voyagerback'
.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally."
I pasted the commands we use to restore the backup and their results below.
Are we doing anything wrong? Is there any way to verify the integrity of a
backup file besides VERIFYONLY (which tells us that the backup is ok)?
Thanks!
Stijn.
RESTORE HEADERONLY
FROM DISK='e:\voyager.bak'
NULL NULL 1 NULL 0 1 2 sa W-UNION1 Voyager 539 2002-09-25 03:50:21.000 51891
20 49000000034700001 49000000035100001 4
9000000034700003 0 2002-09-25 11:16:
01.000 2002-09-25 11:16:02. 000 52 228 1033 196609 80 4608 8 0 194 W
-UNION1 0
{1362433B-7E4A-465F-A852-C
76DF919B2BF} {1362433B-7E4A-465F-A852-C76DF919B2BF} SQL_Latin1_General_CP1_C
I_AS
NULL NULL 5 NULL 0 2 2 sa W-UNION1 Voyager 539 2002-09-25 03:50:21.000 35491
84 56000000003700001 56000000003900001 5
6000000003700001 49000000034700003 2
002-09-24 11:52:27.000 2002-09-24 11:52:29.000 52 228 1033 196609 80 4608 8
0 194 W-UNION1 0 {1362433B-
7E4A-465F-A852-C76DF919B2BF} {1362433B-7E4A-465F-A852-C76DF919B2BF} SQL_Lati
n1_General_CP1_CI_AS
NULL NULL 5 NULL 0 3 2 sa W-UNION1 Voyager 539 2002-09-25 03:50:21.000 20684
8 115000000034600001 115000000034800001
115000000034600001 11500000003390000
3 2003-06-19 07:41:25.000 2003-06-19 07:41:25.000 52 228 1033 196609 80 4608
8 0 194 W-UNION1 0 {136243
3B-7E4A-465F-A852-C76DF919B2BF} {1362433B-7E4A-465F-A852-C76DF919B2BF} SQL_L
atin1_General_CP1_CI_AS
NULL NULL 5 NULL 0 4 2 sa W-UNION1 Voyager 539 2002-09-25 03:50:21.000 39424
00 144000000031100001 144000000031300001
144000000031100001 1150000000339000
03 2002-09-24 01:22:22.000 2002-09-24 01:22:23.000 52 228 1033 196609 80 460
8 8 0 194 W-UNION1 0 {13624
33B-7E4A-465F-A852-C76DF919B2BF} {1362433B-7E4A-465F-A852-C76DF919B2BF} SQL_
Latin1_General_CP1_CI_AS
//cut some lines out to save space
NULL NULL 5 NULL 0 29 2 SA W-UNION1 Voyager 539 2002-09-25 03:50:21.000 1662
09536 2868000000025300001 28680000000255
00001 2868000000025300001 1540000000
51100003 2004-01-09 13:39:07.000 2004-01-09 13:39:53.000 52 228 1033 196609
80 4608 8 0 194 W-UNION1 0
{1362433B-7E4A-465F-A852-C76DF919B2BF} {1362433B-7E4A-465F-A852-C76DF919B2BF
} SQL_Latin1_General_CP1_CI_AS
NULL NULL 5 NULL 0 30 2 sa W-UNION1 Voyager 539 2002-09-25 03:50:21.000 1753
19040 2984000000024100001 29840000000308
00001 2984000000024100001 1540000000
51100003 2004-01-15 10:55:45.000 2004-01-15 10:56:09.000 52 228 1033 196609
80 4608 8 0 194 W-UNION1 0
{1362433B-7E4A-465F-A852-C76DF919B2BF} {1362433B-7E4A-465F-A852-C76DF919B2BF
} SQL_Latin1_General_CP1_CI_AS
NULL NULL 5 NULL 0 31 2 sa W-UNION1 Voyager 539 2002-09-25 03:50:21.000 1988
46464 3358000000038400001 33580000000386
00001 3358000000038400001 1540000000
51100003 2004-01-30 16:44:24.000 2004-01-30 16:44:49.000 52 228 1033 196609
80 4608 8 0 194 W-UNION1 0
{1362433B-7E4A-465F-A852-C76DF919B2BF} {1362433B-7E4A-465F-A852-C76DF919B2BF
} SQL_Latin1_General_CP1_CI_AS
RESTORE FILELISTONLY
FROM DISK='e:\voyager.bak'
Voyager_dat C:\MSDE\MSSQL\Data\Voyager.mdf D PRIMARY 5242880 35184372080640
Voyager_log C:\MSDE\MSSQL\Data\Voyager.ldf L NULL 1048576 35184372080640
RESTORE VERIFYONLY
FROM DISK='e:\voyager.bak'
WITH FILE=31
The backup set is valid.
RESTORE DATABASE Voyagerback
FROM DISK='e:\voyager.bak'
WITH NORECOVERY,
MOVE 'Voyager_dat' TO 'e:\voyager.mdf',
MOVE 'Voyager_log' TO 'e:\voyager.ldf'
Processed 624 pages for database 'Voyagerback', file 'Voyager_dat' on file 1
.
Processed 1 pages for database 'Voyagerback', file 'Voyager_log' on file 1.
RESTORE DATABASE successfully processed 625 pages in 1.051 seconds (4.865 MB
/sec).
RESTORE DATABASE Voyagerback
FROM DISK='e:\voyager.bak'
WITH FILE=31,
MOVE 'Voyager_dat' TO 'e:\voyager.mdf',
MOVE 'Voyager_log' TO 'e:\voyager.ldf'
Server: Msg 3136, Level 16, State 1, Line 1
Cannot apply the backup on device 'e:\voyager.bak' to database 'Voyagerback'
.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.Stijn
Try to specify
RESTORE DATABASE Voyagerback
FROM DISK='e:\voyager.bak'
WITH FILE=31,
RECOVERY,
MOVE 'Voyager_dat' TO 'e:\voyager.mdf',
MOVE 'Voyager_log' TO 'e:\voyager.ldf'
"Stijn" <anonymous@.discussions.microsoft.com> wrote in message
news:B56E7D6D-49C3-4C50-B2D0-F43980DF3949@.microsoft.com...
> We made a backup of one of our databases. The backup was done to disk.
First a full backup and then differentials. When we try to restore this
backup we run into problems... The restore of the full backup works without
problems, the first differential (#2 in the backup set) can also be restored
without problems. But when we try to restore one of the other sets (3 ->
31) we get the following errors:
> "Server: Msg 3136, Level 16, State 1, Line 1
> Cannot apply the backup on device 'e:\voyager.bak' to database
'Voyagerback'.
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally."
> I pasted the commands we use to restore the backup and their results
below. Are we doing anything wrong? Is there any way to verify the
integrity of a backup file besides VERIFYONLY (which tells us that the
backup is ok)?
> Thanks!
> Stijn.
>
> RESTORE HEADERONLY
> FROM DISK='e:\voyager.bak'
> NULL NULL 1 NULL 0 1 2 sa W-UNION1 Voyager 539 2002-09-25 03:50:21.000
5189120 49000000034700001 49000000035100001 49000000034700003 0 2002-09-25
11:16:01.000 2002-09-25 11:16:02.000 52 228 1033 196609 80 4608 8 0 194
W-UNION1 0 {1362433B-7E4A-465F-A852-C76DF919B2BF}
{1362433B-7E4A-465F-A852-C76DF919B2BF} SQL_Latin1_General_CP1_CI_AS
> NULL NULL 5 NULL 0 2 2 sa W-UNION1 Voyager 539 2002-09-25 03:50:21.000
3549184 56000000003700001 56000000003900001 56000000003700001
49000000034700003 2002-09-24 11:52:27.000 2002-09-24 11:52:29.000 52 228
1033 196609 80 4608 8 0 194 W-UNION1 0
{1362433B-7E4A-465F-A852-C76DF919B2BF}
{1362433B-7E4A-465F-A852-C76DF919B2BF} SQL_Latin1_General_CP1_CI_AS
> NULL NULL 5 NULL 0 3 2 sa W-UNION1 Voyager 539 2002-09-25 03:50:21.000
206848 115000000034600001 115000000034800001 115000000034600001
115000000033900003 2003-06-19 07:41:25.000 2003-06-19 07:41:25.000 52 228
1033 196609 80 4608 8 0 194 W-UNION1 0
{1362433B-7E4A-465F-A852-C76DF919B2BF}
{1362433B-7E4A-465F-A852-C76DF919B2BF} SQL_Latin1_General_CP1_CI_AS
> NULL NULL 5 NULL 0 4 2 sa W-UNION1 Voyager 539 2002-09-25 03:50:21.000
3942400 144000000031100001 144000000031300001 144000000031100001
115000000033900003 2002-09-24 01:22:22.000 2002-09-24 01:22:23.000 52 228
1033 196609 80 4608 8 0 194 W-UNION1 0
{1362433B-7E4A-465F-A852-C76DF919B2BF}
{1362433B-7E4A-465F-A852-C76DF919B2BF} SQL_Latin1_General_CP1_CI_AS
> //cut some lines out to save space
> NULL NULL 5 NULL 0 29 2 SA W-UNION1 Voyager 539 2002-09-25 03:50:21.000
166209536 2868000000025300001 2868000000025500001 2868000000025300001
154000000051100003 2004-01-09 13:39:07.000 2004-01-09 13:39:53.000 52 228
1033 196609 80 4608 8 0 194 W-UNION1 0
{1362433B-7E4A-465F-A852-C76DF919B2BF}
{1362433B-7E4A-465F-A852-C76DF919B2BF} SQL_Latin1_General_CP1_CI_AS
> NULL NULL 5 NULL 0 30 2 sa W-UNION1 Voyager 539 2002-09-25 03:50:21.000
175319040 2984000000024100001 2984000000030800001 2984000000024100001
154000000051100003 2004-01-15 10:55:45.000 2004-01-15 10:56:09.000 52 228
1033 196609 80 4608 8 0 194 W-UNION1 0
{1362433B-7E4A-465F-A852-C76DF919B2BF}
{1362433B-7E4A-465F-A852-C76DF919B2BF} SQL_Latin1_General_CP1_CI_AS
> NULL NULL 5 NULL 0 31 2 sa W-UNION1 Voyager 539 2002-09-25 03:50:21.000
198846464 3358000000038400001 3358000000038600001 3358000000038400001
154000000051100003 2004-01-30 16:44:24.000 2004-01-30 16:44:49.000 52 228
1033 196609 80 4608 8 0 194 W-UNION1 0
{1362433B-7E4A-465F-A852-C76DF919B2BF}
{1362433B-7E4A-465F-A852-C76DF919B2BF} SQL_Latin1_General_CP1_CI_AS
>
> --
> RESTORE FILELISTONLY
> FROM DISK='e:\voyager.bak'
> Voyager_dat C:\MSDE\MSSQL\Data\Voyager.mdf D PRIMARY 5242880
35184372080640
> Voyager_log C:\MSDE\MSSQL\Data\Voyager.ldf L NULL 1048576 35184372080640
> --
> RESTORE VERIFYONLY
> FROM DISK='e:\voyager.bak'
> WITH FILE=31
> The backup set is valid.
> --
> RESTORE DATABASE Voyagerback
> FROM DISK='e:\voyager.bak'
> WITH NORECOVERY,
> MOVE 'Voyager_dat' TO 'e:\voyager.mdf',
> MOVE 'Voyager_log' TO 'e:\voyager.ldf'
> Processed 624 pages for database 'Voyagerback', file 'Voyager_dat' on file
1.
> Processed 1 pages for database 'Voyagerback', file 'Voyager_log' on file
1.
> RESTORE DATABASE successfully processed 625 pages in 1.051 seconds (4.865
MB/sec).
> --
> RESTORE DATABASE Voyagerback
> FROM DISK='e:\voyager.bak'
> WITH FILE=31,
> MOVE 'Voyager_dat' TO 'e:\voyager.mdf',
> MOVE 'Voyager_log' TO 'e:\voyager.ldf'
> Server: Msg 3136, Level 16, State 1, Line 1
> Cannot apply the backup on device 'e:\voyager.bak' to database
'Voyagerback'.
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
>
>|||Same problem with the RECOVERY option...
Anyway thanks for your reply!|||I would check the backup history tables in msdb, perhaps someone did a
database backup to some other backupdevice between number 2 and number 3 on
your backup device? Watch out for VERIFYONLY. It basically only verifies
that the file/tape is readable. Only way to do a proper verification is to
do an actual restore. Yukon will be better in this aspect.
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=...ublic.sqlserver
"Stijn" <anonymous@.discussions.microsoft.com> wrote in message
news:B56E7D6D-49C3-4C50-B2D0-F43980DF3949@.microsoft.com...
> We made a backup of one of our databases. The backup was done to disk.
First a full backup and then differentials. When we try to restore this
backup we run into problems... The restore of the full backup works without
problems, the first differential (#2 in the backup set) can also be restored
without problems. But when we try to restore one of the other sets (3 ->
31) we get the following errors:
> "Server: Msg 3136, Level 16, State 1, Line 1
> Cannot apply the backup on device 'e:\voyager.bak' to database
'Voyagerback'.
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally."
> I pasted the commands we use to restore the backup and their results
below. Are we doing anything wrong? Is there any way to verify the
integrity of a backup file besides VERIFYONLY (which tells us that the
backup is ok)?
> Thanks!
> Stijn.
>
> RESTORE HEADERONLY
> FROM DISK='e:\voyager.bak'
> NULL NULL 1 NULL 0 1 2 sa W-UNION1 Voyager 539 2002-09-25 03:50:21.000
5189120 49000000034700001 49000000035100001 49000000034700003 0 2002-09-25
11:16:01.000 2002-09-25 11:16:02.000 52 228 1033 196609 80 4608 8 0 194
W-UNION1 0 {1362433B-7E4A-465F-A852-C76DF919B2BF}
{1362433B-7E4A-465F-A852-C76DF919B2BF} SQL_Latin1_General_CP1_CI_AS
> NULL NULL 5 NULL 0 2 2 sa W-UNION1 Voyager 539 2002-09-25 03:50:21.000
3549184 56000000003700001 56000000003900001 56000000003700001
49000000034700003 2002-09-24 11:52:27.000 2002-09-24 11:52:29.000 52 228
1033 196609 80 4608 8 0 194 W-UNION1 0
{1362433B-7E4A-465F-A852-C76DF919B2BF}
{1362433B-7E4A-465F-A852-C76DF919B2BF} SQL_Latin1_General_CP1_CI_AS
> NULL NULL 5 NULL 0 3 2 sa W-UNION1 Voyager 539 2002-09-25 03:50:21.000
206848 115000000034600001 115000000034800001 115000000034600001
115000000033900003 2003-06-19 07:41:25.000 2003-06-19 07:41:25.000 52 228
1033 196609 80 4608 8 0 194 W-UNION1 0
{1362433B-7E4A-465F-A852-C76DF919B2BF}
{1362433B-7E4A-465F-A852-C76DF919B2BF} SQL_Latin1_General_CP1_CI_AS
> NULL NULL 5 NULL 0 4 2 sa W-UNION1 Voyager 539 2002-09-25 03:50:21.000
3942400 144000000031100001 144000000031300001 144000000031100001
115000000033900003 2002-09-24 01:22:22.000 2002-09-24 01:22:23.000 52 228
1033 196609 80 4608 8 0 194 W-UNION1 0
{1362433B-7E4A-465F-A852-C76DF919B2BF}
{1362433B-7E4A-465F-A852-C76DF919B2BF} SQL_Latin1_General_CP1_CI_AS
> //cut some lines out to save space
> NULL NULL 5 NULL 0 29 2 SA W-UNION1 Voyager 539 2002-09-25 03:50:21.000
166209536 2868000000025300001 2868000000025500001 2868000000025300001
154000000051100003 2004-01-09 13:39:07.000 2004-01-09 13:39:53.000 52 228
1033 196609 80 4608 8 0 194 W-UNION1 0
{1362433B-7E4A-465F-A852-C76DF919B2BF}
{1362433B-7E4A-465F-A852-C76DF919B2BF} SQL_Latin1_General_CP1_CI_AS
> NULL NULL 5 NULL 0 30 2 sa W-UNION1 Voyager 539 2002-09-25 03:50:21.000
175319040 2984000000024100001 2984000000030800001 2984000000024100001
154000000051100003 2004-01-15 10:55:45.000 2004-01-15 10:56:09.000 52 228
1033 196609 80 4608 8 0 194 W-UNION1 0
{1362433B-7E4A-465F-A852-C76DF919B2BF}
{1362433B-7E4A-465F-A852-C76DF919B2BF} SQL_Latin1_General_CP1_CI_AS
> NULL NULL 5 NULL 0 31 2 sa W-UNION1 Voyager 539 2002-09-25 03:50:21.000
198846464 3358000000038400001 3358000000038600001 3358000000038400001
154000000051100003 2004-01-30 16:44:24.000 2004-01-30 16:44:49.000 52 228
1033 196609 80 4608 8 0 194 W-UNION1 0
{1362433B-7E4A-465F-A852-C76DF919B2BF}
{1362433B-7E4A-465F-A852-C76DF919B2BF} SQL_Latin1_General_CP1_CI_AS
>
> --
> RESTORE FILELISTONLY
> FROM DISK='e:\voyager.bak'
> Voyager_dat C:\MSDE\MSSQL\Data\Voyager.mdf D PRIMARY 5242880
35184372080640
> Voyager_log C:\MSDE\MSSQL\Data\Voyager.ldf L NULL 1048576 35184372080640
> --
> RESTORE VERIFYONLY
> FROM DISK='e:\voyager.bak'
> WITH FILE=31
> The backup set is valid.
> --
> RESTORE DATABASE Voyagerback
> FROM DISK='e:\voyager.bak'
> WITH NORECOVERY,
> MOVE 'Voyager_dat' TO 'e:\voyager.mdf',
> MOVE 'Voyager_log' TO 'e:\voyager.ldf'
> Processed 624 pages for database 'Voyagerback', file 'Voyager_dat' on file
1.
> Processed 1 pages for database 'Voyagerback', file 'Voyager_log' on file
1.
> RESTORE DATABASE successfully processed 625 pages in 1.051 seconds (4.865
MB/sec).
> --
> RESTORE DATABASE Voyagerback
> FROM DISK='e:\voyager.bak'
> WITH FILE=31,
> MOVE 'Voyager_dat' TO 'e:\voyager.mdf',
> MOVE 'Voyager_log' TO 'e:\voyager.ldf'
> Server: Msg 3136, Level 16, State 1, Line 1
> Cannot apply the backup on device 'e:\voyager.bak' to database
'Voyagerback'.
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
>
>