Differential DB Restore Script Help

I am trying to restore a differential backup on top of the
restored full backup and getting the following error:
Server: Msg 3136, Level 16, State 1, Line 1
Cannot apply the backup on device 'F:\HISTORY backup.BAK'
to database 'HISTORY'.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Here is my script:
RESTORE DATABASE HISTORY
FROM DISK = 'F:\HISTORY backup.BAK'
WITH
DBO_ONLY,
REPLACE,
STANDBY = 'F:\UNDO_WPHISTORY.ldf',
MOVE 'HISTORY_dat1' TO 'E:\Program Files\Microsoft SQL
Server\MSSQL\Data\WPHISTORY_dat1.mdf',
MOVE 'HISTORY_log1' TO 'E:\Program Files\Microsoft SQL
Server\MSSQL\Data\HISTORY_log1.ldf'
---
I am thinking that it has something to do with backup
date/time.
Any help will be appreciated.Use RESTORE HEADERONLY to investigate what is on the backup files. Also,
check the sysbackuphistory tables in msdb to determine if you had any db
backup in between the db and diff backup you try to restore.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"calvin" <anonymous@.discussions.microsoft.com> wrote in message
news:018101c3a7c9$442a16e0$a501280a@.phx.gbl...
> I am trying to restore a differential backup on top of the
> restored full backup and getting the following error:
> Server: Msg 3136, Level 16, State 1, Line 1
> Cannot apply the backup on device 'F:\HISTORY backup.BAK'
> to database 'HISTORY'.
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
> Here is my script:
> RESTORE DATABASE HISTORY
> FROM DISK = 'F:\HISTORY backup.BAK'
> WITH
> DBO_ONLY,
> REPLACE,
> STANDBY = 'F:\UNDO_WPHISTORY.ldf',
> MOVE 'HISTORY_dat1' TO 'E:\Program Files\Microsoft SQL
> Server\MSSQL\Data\WPHISTORY_dat1.mdf',
> MOVE 'HISTORY_log1' TO 'E:\Program Files\Microsoft SQL
> Server\MSSQL\Data\HISTORY_log1.ldf'
> ---
> I am thinking that it has something to do with backup
> date/time.
> Any help will be appreciated.
>|||Yes. There are Transaction log backups between the Full
backup anf the Differential backup (Differential backup is
the latest).
>--Original Message--
>Use RESTORE HEADERONLY to investigate what is on the
backup files. Also,
>check the sysbackuphistory tables in msdb to determine if
you had any db
>backup in between the db and diff backup you try to
restore.
>--
>Tibor Karaszi, SQL Server MVP
>Archive at:
>http://groups.google.com/groups?
oi=djq&as_ugroup=microsoft.public.sqlserver
>
>"calvin" <anonymous@.discussions.microsoft.com> wrote in
message
>news:018101c3a7c9$442a16e0$a501280a@.phx.gbl...
>> I am trying to restore a differential backup on top of
the
>> restored full backup and getting the following error:
>> Server: Msg 3136, Level 16, State 1, Line 1
>> Cannot apply the backup on device 'F:\HISTORY
backup.BAK'
>> to database 'HISTORY'.
>> Server: Msg 3013, Level 16, State 1, Line 1
>> RESTORE DATABASE is terminating abnormally.
>> Here is my script:
>> RESTORE DATABASE HISTORY
>> FROM DISK = 'F:\HISTORY backup.BAK'
>> WITH
>> DBO_ONLY,
>> REPLACE,
>> STANDBY = 'F:\UNDO_WPHISTORY.ldf',
>> MOVE 'HISTORY_dat1' TO 'E:\Program Files\Microsoft SQL
>> Server\MSSQL\Data\WPHISTORY_dat1.mdf',
>> MOVE 'HISTORY_log1' TO 'E:\Program Files\Microsoft SQL
>> Server\MSSQL\Data\HISTORY_log1.ldf'
>> ---
>> I am thinking that it has something to do with backup
>> date/time.
>> Any help will be appreciated.
>>
>
>.
>|||Silly ? but did you use the right full backup? You can
only apply a differential to its proper full.
>--Original Message--
>Yes. There are Transaction log backups between the Full
>backup anf the Differential backup (Differential backup
is
>the latest).
>
>>--Original Message--
>>Use RESTORE HEADERONLY to investigate what is on the
>backup files. Also,
>>check the sysbackuphistory tables in msdb to determine
if
>you had any db
>>backup in between the db and diff backup you try to
>restore.
>>--
>>Tibor Karaszi, SQL Server MVP
>>Archive at:
>>http://groups.google.com/groups?
>oi=djq&as_ugroup=microsoft.public.sqlserver
>>
>>"calvin" <anonymous@.discussions.microsoft.com> wrote in
>message
>>news:018101c3a7c9$442a16e0$a501280a@.phx.gbl...
>> I am trying to restore a differential backup on top of
>the
>> restored full backup and getting the following error:
>> Server: Msg 3136, Level 16, State 1, Line 1
>> Cannot apply the backup on device 'F:\HISTORY
>backup.BAK'
>> to database 'HISTORY'.
>> Server: Msg 3013, Level 16, State 1, Line 1
>> RESTORE DATABASE is terminating abnormally.
>> Here is my script:
>> RESTORE DATABASE HISTORY
>> FROM DISK = 'F:\HISTORY backup.BAK'
>> WITH
>> DBO_ONLY,
>> REPLACE,
>> STANDBY = 'F:\UNDO_WPHISTORY.ldf',
>> MOVE 'HISTORY_dat1' TO 'E:\Program Files\Microsoft SQL
>> Server\MSSQL\Data\WPHISTORY_dat1.mdf',
>> MOVE 'HISTORY_log1' TO 'E:\Program Files\Microsoft SQL
>> Server\MSSQL\Data\HISTORY_log1.ldf'
>> ---
>> I am thinking that it has something to do with backup
>> date/time.
>> Any help will be appreciated.
>>
>>
>>.
>.
>|||I wasn't referring to t-log backups between the db and the diff backup. I
was referring to *db backups* between the db backup you try to restore and
the diff backup you try to restore.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Calvin" <anonymous@.discussions.microsoft.com> wrote in message
news:022b01c3a7d1$b509aee0$a501280a@.phx.gbl...
> Yes. There are Transaction log backups between the Full
> backup anf the Differential backup (Differential backup is
> the latest).
>
> >--Original Message--
> >Use RESTORE HEADERONLY to investigate what is on the
> backup files. Also,
> >check the sysbackuphistory tables in msdb to determine if
> you had any db
> >backup in between the db and diff backup you try to
> restore.
> >
> >--
> >Tibor Karaszi, SQL Server MVP
> >Archive at:
> >http://groups.google.com/groups?
> oi=djq&as_ugroup=microsoft.public.sqlserver
> >
> >
> >"calvin" <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:018101c3a7c9$442a16e0$a501280a@.phx.gbl...
> >> I am trying to restore a differential backup on top of
> the
> >> restored full backup and getting the following error:
> >>
> >> Server: Msg 3136, Level 16, State 1, Line 1
> >> Cannot apply the backup on device 'F:\HISTORY
> backup.BAK'
> >> to database 'HISTORY'.
> >> Server: Msg 3013, Level 16, State 1, Line 1
> >> RESTORE DATABASE is terminating abnormally.
> >>
> >> Here is my script:
> >> RESTORE DATABASE HISTORY
> >> FROM DISK = 'F:\HISTORY backup.BAK'
> >> WITH
> >> DBO_ONLY,
> >> REPLACE,
> >> STANDBY = 'F:\UNDO_WPHISTORY.ldf',
> >> MOVE 'HISTORY_dat1' TO 'E:\Program Files\Microsoft SQL
> >> Server\MSSQL\Data\WPHISTORY_dat1.mdf',
> >> MOVE 'HISTORY_log1' TO 'E:\Program Files\Microsoft SQL
> >> Server\MSSQL\Data\HISTORY_log1.ldf'
> >> ---
> >> I am thinking that it has something to do with backup
> >> date/time.
> >>
> >> Any help will be appreciated.
> >>
> >>
> >
> >
> >.
> >|||No. There is no database backups between the last full
backup which I restored and the differential backup.
and for Allen, yes it is the correct full backup.
Thanks.
>--Original Message--
>I wasn't referring to t-log backups between the db and
the diff backup. I
>was referring to *db backups* between the db backup you
try to restore and
>the diff backup you try to restore.
>--
>Tibor Karaszi, SQL Server MVP
>Archive at:
>http://groups.google.com/groups?
oi=djq&as_ugroup=microsoft.public.sqlserver
>
>"Calvin" <anonymous@.discussions.microsoft.com> wrote in
message
>news:022b01c3a7d1$b509aee0$a501280a@.phx.gbl...
>> Yes. There are Transaction log backups between the Full
>> backup anf the Differential backup (Differential backup
is
>> the latest).
>>
>> >--Original Message--
>> >Use RESTORE HEADERONLY to investigate what is on the
>> backup files. Also,
>> >check the sysbackuphistory tables in msdb to determine
if
>> you had any db
>> >backup in between the db and diff backup you try to
>> restore.
>> >
>> >--
>> >Tibor Karaszi, SQL Server MVP
>> >Archive at:
>> >http://groups.google.com/groups?
>> oi=djq&as_ugroup=microsoft.public.sqlserver
>> >
>> >
>> >"calvin" <anonymous@.discussions.microsoft.com> wrote in
>> message
>> >news:018101c3a7c9$442a16e0$a501280a@.phx.gbl...
>> >> I am trying to restore a differential backup on top
of
>> the
>> >> restored full backup and getting the following error:
>> >>
>> >> Server: Msg 3136, Level 16, State 1, Line 1
>> >> Cannot apply the backup on device 'F:\HISTORY
>> backup.BAK'
>> >> to database 'HISTORY'.
>> >> Server: Msg 3013, Level 16, State 1, Line 1
>> >> RESTORE DATABASE is terminating abnormally.
>> >>
>> >> Here is my script:
>> >> RESTORE DATABASE HISTORY
>> >> FROM DISK = 'F:\HISTORY backup.BAK'
>> >> WITH
>> >> DBO_ONLY,
>> >> REPLACE,
>> >> STANDBY = 'F:\UNDO_WPHISTORY.ldf',
>> >> MOVE 'HISTORY_dat1' TO 'E:\Program Files\Microsoft
SQL
>> >> Server\MSSQL\Data\WPHISTORY_dat1.mdf',
>> >> MOVE 'HISTORY_log1' TO 'E:\Program Files\Microsoft
SQL
>> >> Server\MSSQL\Data\HISTORY_log1.ldf'
>> >> ----
-
>> >> I am thinking that it has something to do with backup
>> >> date/time.
>> >>
>> >> Any help will be appreciated.
>> >>
>> >>
>> >
>> >
>> >.
>> >
>
>.
>|||Are you absolutely 100% certain? Did you check against the sysbackuphistory
tables in msdb?
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Calvin" <anonymous@.discussions.microsoft.com> wrote in message
news:02c601c3a7da$1371a570$a501280a@.phx.gbl...
> No. There is no database backups between the last full
> backup which I restored and the differential backup.
> and for Allen, yes it is the correct full backup.
> Thanks.
>
> >--Original Message--
> >I wasn't referring to t-log backups between the db and
> the diff backup. I
> >was referring to *db backups* between the db backup you
> try to restore and
> >the diff backup you try to restore.
> >
> >--
> >Tibor Karaszi, SQL Server MVP
> >Archive at:
> >http://groups.google.com/groups?
> oi=djq&as_ugroup=microsoft.public.sqlserver
> >
> >
> >"Calvin" <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:022b01c3a7d1$b509aee0$a501280a@.phx.gbl...
> >> Yes. There are Transaction log backups between the Full
> >> backup anf the Differential backup (Differential backup
> is
> >> the latest).
> >>
> >>
> >>
> >> >--Original Message--
> >> >Use RESTORE HEADERONLY to investigate what is on the
> >> backup files. Also,
> >> >check the sysbackuphistory tables in msdb to determine
> if
> >> you had any db
> >> >backup in between the db and diff backup you try to
> >> restore.
> >> >
> >> >--
> >> >Tibor Karaszi, SQL Server MVP
> >> >Archive at:
> >> >http://groups.google.com/groups?
> >> oi=djq&as_ugroup=microsoft.public.sqlserver
> >> >
> >> >
> >> >"calvin" <anonymous@.discussions.microsoft.com> wrote in
> >> message
> >> >news:018101c3a7c9$442a16e0$a501280a@.phx.gbl...
> >> >> I am trying to restore a differential backup on top
> of
> >> the
> >> >> restored full backup and getting the following error:
> >> >>
> >> >> Server: Msg 3136, Level 16, State 1, Line 1
> >> >> Cannot apply the backup on device 'F:\HISTORY
> >> backup.BAK'
> >> >> to database 'HISTORY'.
> >> >> Server: Msg 3013, Level 16, State 1, Line 1
> >> >> RESTORE DATABASE is terminating abnormally.
> >> >>
> >> >> Here is my script:
> >> >> RESTORE DATABASE HISTORY
> >> >> FROM DISK = 'F:\HISTORY backup.BAK'
> >> >> WITH
> >> >> DBO_ONLY,
> >> >> REPLACE,
> >> >> STANDBY = 'F:\UNDO_WPHISTORY.ldf',
> >> >> MOVE 'HISTORY_dat1' TO 'E:\Program Files\Microsoft
> SQL
> >> >> Server\MSSQL\Data\WPHISTORY_dat1.mdf',
> >> >> MOVE 'HISTORY_log1' TO 'E:\Program Files\Microsoft
> SQL
> >> >> Server\MSSQL\Data\HISTORY_log1.ldf'
> >> >> ----
> -
> >> >> I am thinking that it has something to do with backup
> >> >> date/time.
> >> >>
> >> >> Any help will be appreciated.
> >> >>
> >> >>
> >> >
> >> >
> >> >.
> >> >
> >
> >
> >.
> >