I cannot restore a differential database backup on top of a full back up for
some reason. I am installing it on a seperate server from a "device" , i
dont know what I ma doing wrong. Obviously I am new to sql server
administration. Any help will be appreciated.
best
JayAlso, please post the exact error message...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"John" <anonymous@.discussions.microsoft.com> wrote in message news:22f7001c45e15$ba2d4670$a301280a@.phx.gbl...
> Is there another backup between the full backup and
> differential backup'
>
> >--Original Message--
> >I cannot restore a differential database backup on top of
> a full back up for
> >some reason. I am installing it on a seperate server from
> a "device" , i
> >dont know what I ma doing wrong. Obviously I am new to
> sql server
> >administration. Any help will be appreciated.
> >
> >best
> >Jay
> >
> >
> >.
> >|||No there isnt another backup between the Full and differential database
backup.
The exact error message is somehting of the effect that
"Microsoft SQL-DMO(ODBC SQL State:42000)
Cannot apply the backup on device 'D:\TestDB\x-D.bak' to database 'X'.
RESTORE DATABASE is terminating abnormally.
Its kinds frusterating because I dont know enough about the subject to be
able to troubleshoot this error convinceingly. I appreciate the help you
guys are offereing.
-Jay
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:e5yevchXEHA.648@.TK2MSFTNGP10.phx.gbl...
> Also, please post the exact error message...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "John" <anonymous@.discussions.microsoft.com> wrote in message
news:22f7001c45e15$ba2d4670$a301280a@.phx.gbl...
> > Is there another backup between the full backup and
> > differential backup'
> >
> >
> >
> > >--Original Message--
> > >I cannot restore a differential database backup on top of
> > a full back up for
> > >some reason. I am installing it on a seperate server from
> > a "device" , i
> > >dont know what I ma doing wrong. Obviously I am new to
> > sql server
> > >administration. Any help will be appreciated.
> > >
> > >best
> > >Jay
> > >
> > >
> > >.
> > >
>|||Hi,
You have to restore the full database backup with "norecovery" and then
restoring the
differential with "recovery" option. If you have not specified the
NORECOVERY option during your
FULL backup restore , the database will become open and you will not be able
to apply a subsequent backups (
Differential or transaction log) above that
RESTORE Database <dbname> from disk='fullbackup' with NORECOVERY
go
RESTORE Database <dbname> from disk='diff_backup' with RECOVERY
Thanks
Hari
MCDBA
"Jay Taylor" <help4u@.gmail.com> wrote in message
news:uZqceShXEHA.3640@.TK2MSFTNGP11.phx.gbl...
> I cannot restore a differential database backup on top of a full back up
for
> some reason. I am installing it on a seperate server from a "device" , i
> dont know what I ma doing wrong. Obviously I am new to sql server
> administration. Any help will be appreciated.
> best
> Jay
>|||I'm sorry but I can't really be of more help. I would triple check that you indeed work against the
correct backup files (also use RESTORE HEADERONLY), and that you really really don't have a database
backup in between. Also, do a simple test case against pubs or so, and verify that the test case
work as you expect.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Jay Taylor" <help4u@.gmail.com> wrote in message news:OpEpnyjXEHA.648@.TK2MSFTNGP10.phx.gbl...
> No there isnt another backup between the Full and differential database
> backup.
> The exact error message is somehting of the effect that
> "Microsoft SQL-DMO(ODBC SQL State:42000)
> Cannot apply the backup on device 'D:\TestDB\x-D.bak' to database 'X'.
> RESTORE DATABASE is terminating abnormally.
> Its kinds frusterating because I dont know enough about the subject to be
> able to troubleshoot this error convinceingly. I appreciate the help you
> guys are offereing.
> -Jay
>
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:e5yevchXEHA.648@.TK2MSFTNGP10.phx.gbl...
> > Also, please post the exact error message...
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> > http://www.solidqualitylearning.com/
> >
> >
> > "John" <anonymous@.discussions.microsoft.com> wrote in message
> news:22f7001c45e15$ba2d4670$a301280a@.phx.gbl...
> > > Is there another backup between the full backup and
> > > differential backup'
> > >
> > >
> > >
> > > >--Original Message--
> > > >I cannot restore a differential database backup on top of
> > > a full back up for
> > > >some reason. I am installing it on a seperate server from
> > > a "device" , i
> > > >dont know what I ma doing wrong. Obviously I am new to
> > > sql server
> > > >administration. Any help will be appreciated.
> > > >
> > > >best
> > > >Jay
> > > >
> > > >
> > > >.
> > > >
> >
> >
>
