Thursday, March 8, 2012

database restore issue

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
>
>.
>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$a3
01280a@.phx.gbl...[vbcol=seagreen]
> Is there another backup between the full backup and
> differential backup'
>
>
> a full back up for
> a "device" , i
> sql server|||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...
>|||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 real
ly don't have a database
backup in between. Also, do a simple test case against pubs or so, and verif
y 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 i
n
> message news:e5yevchXEHA.648@.TK2MSFTNGP10.phx.gbl...
> news:22f7001c45e15$ba2d4670$a301280a@.phx
.gbl...
>

No comments:

Post a Comment