Restore of backup fails, backup file corrupt?

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
Cannot apply the backup on device 'e:\voyager.bak' to database 'Voyagerback'
Server: Msg 3013, Level 16, State 1, Line
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 HEADERONL
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_A
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_A
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_A
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_A
//cut some lines out to save spac
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_A
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_A
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_A
--
RESTORE FILELISTONL
FROM DISK='e:\voyager.bak
Voyager_dat C:\MSDE\MSSQL\Data\Voyager.mdf D PRIMARY 5242880 3518437208064
Voyager_log C:\MSDE\MSSQL\Data\Voyager.ldf L NULL 1048576 3518437208064
--
RESTORE VERIFYONL
FROM DISK='e:\voyager.bak
WITH FILE=3
The backup set is valid
--
RESTORE DATABASE Voyagerbac
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=djq&as_ugroup=microsoft.public.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.
>
>