restoring incremental backup fails

Hi, I'm trying to restore an incremental backup but it
fails. Here are the TSQL commands and the results. Any
idea?
RESTORE DATABASE [LWHKPROD] FROM DISK =
N'D:\ASIA\LWHKPROD as of May 31.bak' WITH FILE = 1,
NOUNLOAD , STATS = 10, NORECOVERY , MOVE N'lwxpertData'
TO N'F:\sql2000\Data\LWHKPROD.mdf', MOVE N'lwxpert_log'
TO N'D:\sql2000\logs\LWHKPROD_log.ldf'
go
RESTORE DATABASE [LWHKPROD] FROM DISK =
N'D:\ASIA\LWHKPROD-Tue.bak' WITH FILE = 1, NOUNLOAD ,
STATS = 10, RECOVERY , MOVE N'lwxpertData' TO
N'F:\sql2000\Data\LWHKPROD.mdf', MOVE N'lwxpert_log' TO
N'D:\sql2000\logs\LWHKPROD_log.ldf'
go
Results:
...
100 percent restored.
Processed 20312 pages for database 'LWHKPROD',
file 'lwxpertData' on file 1.
Processed 1 pages for database 'LWHKPROD',
file 'lwxpert_log' on file 1.
RESTORE DATABASE successfully processed 20313 pages in
9.794 seconds (16.989 MB/sec).
Server: Msg 3136, Level 16, State 1, Line 1
Cannot apply the backup on device 'D:\ASIA\LWHKPROD-
Tue.bak' to database 'LWHKPROD'.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Was the backup "LWHKPROD-Tue.bak" actually backed up using the WITH
DIFFERENTIAL clause? Show the T-SQL for the backups too.
Eric
PepitoDBA wrote:
> Hi, I'm trying to restore an incremental backup but it
> fails. Here are the TSQL commands and the results. Any
> idea?
> RESTORE DATABASE [LWHKPROD] FROM DISK =
> N'D:\ASIA\LWHKPROD as of May 31.bak' WITH FILE = 1,
> NOUNLOAD , STATS = 10, NORECOVERY , MOVE N'lwxpertData'
> TO N'F:\sql2000\Data\LWHKPROD.mdf', MOVE N'lwxpert_log'
> TO N'D:\sql2000\logs\LWHKPROD_log.ldf'
> go
> RESTORE DATABASE [LWHKPROD] FROM DISK =
> N'D:\ASIA\LWHKPROD-Tue.bak' WITH FILE = 1, NOUNLOAD ,
> STATS = 10, RECOVERY , MOVE N'lwxpertData' TO
> N'F:\sql2000\Data\LWHKPROD.mdf', MOVE N'lwxpert_log' TO
> N'D:\sql2000\logs\LWHKPROD_log.ldf'
> go
> Results:
> ...
> 100 percent restored.
> Processed 20312 pages for database 'LWHKPROD',
> file 'lwxpertData' on file 1.
> Processed 1 pages for database 'LWHKPROD',
> file 'lwxpert_log' on file 1.
> RESTORE DATABASE successfully processed 20313 pages in
> 9.794 seconds (16.989 MB/sec).
> Server: Msg 3136, Level 16, State 1, Line 1
> Cannot apply the backup on device 'D:\ASIA\LWHKPROD-
> Tue.bak' to database 'LWHKPROD'.
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
|||Run the following to confirm that LWHKPROD-Tue.bak' is a differential
backup file:
RESTORE HEADERONLY FROM DISK = 'D:\ASIA\LWHKPROD-Tue.bak'
Look at the BackupType column to check if the value is 5 (a differential
backup).
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backups? Try MiniSQLBackup
"PepitoDBA" <anonymous@.discussions.microsoft.com> wrote in message
news:16f7601c448c7$b531fb60$a601280a@.phx.gbl...
> Hi, I'm trying to restore an incremental backup but it
> fails. Here are the TSQL commands and the results. Any
> idea?
> RESTORE DATABASE [LWHKPROD] FROM DISK =
> N'D:\ASIA\LWHKPROD as of May 31.bak' WITH FILE = 1,
> NOUNLOAD , STATS = 10, NORECOVERY , MOVE N'lwxpertData'
> TO N'F:\sql2000\Data\LWHKPROD.mdf', MOVE N'lwxpert_log'
> TO N'D:\sql2000\logs\LWHKPROD_log.ldf'
> go
> RESTORE DATABASE [LWHKPROD] FROM DISK =
> N'D:\ASIA\LWHKPROD-Tue.bak' WITH FILE = 1, NOUNLOAD ,
> STATS = 10, RECOVERY , MOVE N'lwxpertData' TO
> N'F:\sql2000\Data\LWHKPROD.mdf', MOVE N'lwxpert_log' TO
> N'D:\sql2000\logs\LWHKPROD_log.ldf'
> go
> Results:
> ...
> 100 percent restored.
> Processed 20312 pages for database 'LWHKPROD',
> file 'lwxpertData' on file 1.
> Processed 1 pages for database 'LWHKPROD',
> file 'lwxpert_log' on file 1.
> RESTORE DATABASE successfully processed 20313 pages in
> 9.794 seconds (16.989 MB/sec).
> Server: Msg 3136, Level 16, State 1, Line 1
> Cannot apply the backup on device 'D:\ASIA\LWHKPROD-
> Tue.bak' to database 'LWHKPROD'.
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
>
|||Yes, it is a type 5 (incremental)
>--Original Message--
>Was the backup "LWHKPROD-Tue.bak" actually backed up
using the WITH[vbcol=seagreen]
>DIFFERENTIAL clause? Show the T-SQL for the backups too.
>Eric
>
>PepitoDBA wrote:
N'lwxpertData'
>
>.
>
|||Was there a full backup made between 31 May and June 2 i.e. the date of the
differential backup you are trying to restore? You could look at the
backupset table e.g.
SELECT type, * FROM msdb..backupset WHERE name = 'LWHKPROD' AND
backup_start_date > '31-May-2004' ORDER BY backup_start_date
Peter Yeoh
http://www.yohz.com
Need smaller backup files? Try MiniSQLBackup
"PepitoDBA" <anonymous@.discussions.microsoft.com> wrote in message
news:17b0401c44942$1088da90$a001280a@.phx.gbl...[vbcol=seagreen]
> Yes, it is a type 5 (incremental)
> using the WITH
> N'lwxpertData'