Restore problem - it's beaten me :(

Hi, I just can't for the life of me get my dbases back.
I restore the Full database ok, but I can't apply the differentials at
all - on *any* database I've got.
All the details (quite a few pics) are here:
http://homepages.paradise.net.nz/duncanm4/sqlrestore/
please, if you can see the problem, I'd sure appreciate knowing about
it.
If further details are required, please reply to the NG.
TIA
--
DuncanThis is a known SQL2000 problem.
To Fix install Latest SQL SP
>--Original Message--
>Hi, I just can't for the life of me get my dbases back.
>I restore the Full database ok, but I can't apply the
differentials at
>all - on *any* database I've got.
>All the details (quite a few pics) are here:
>http://homepages.paradise.net.nz/duncanm4/sqlrestore/
>please, if you can see the problem, I'd sure appreciate
knowing about
>it.
>If further details are required, please reply to the NG.
>TIA
>--
>Duncan
>.
>|||In article <MPG.1a163f978c187ade989742@.msnews.microsoft.com>,
hard@.work.ok says...
> Hi, I just can't for the life of me get my dbases back.
> I restore the Full database ok, but I can't apply the differentials at
> all - on *any* database I've got.
> All the details (quite a few pics) are here:
> http://homepages.paradise.net.nz/duncanm4/sqlrestore/
> please, if you can see the problem, I'd sure appreciate knowing about
> it.
> If further details are required, please reply to the NG.
> TIA
OK, I'm goddamn blind - yes, 22nd <> 29th !@.!@.#!@.
It has already been sugested that I begin masterbating backwards,
thankyou!
--
Duncan|||In article <086501c3a51f$0b263b50$a501280a@.phx.gbl>,
anonymous@.discussions.microsoft.com says...
> This is a known SQL2000 problem.
> To Fix install Latest SQL SP
Thanks Brian, it was found to be a PEBKAC problem.
--
Duncan|||Does below work on your machine? I'm on SQL2K sp1.
CREATE TABLE pubs..test(id int identity)
insert pubs..test default values
BACKUP DATABASE pubs TO DISK = 'C:\p.bak' WITH INIT
insert pubs..test default values
BACKUP DATABASE pubs TO DISK = 'C:\p.bak' WITH DIFFERENTIAL
RESTORE DATABASE pubs FROM DISK = 'C:\p.bak' WITH FILE = 1, NORECOVERY
RESTORE DATABASE pubs FROM DISK = 'C:\p.bak' WITH FILE = 2, RECOVERY
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Duncan McC" <hard@.work.ok> wrote in message
news:MPG.1a163f978c187ade989742@.msnews.microsoft.com...
> Hi, I just can't for the life of me get my dbases back.
> I restore the Full database ok, but I can't apply the differentials at
> all - on *any* database I've got.
> All the details (quite a few pics) are here:
> http://homepages.paradise.net.nz/duncanm4/sqlrestore/
> please, if you can see the problem, I'd sure appreciate knowing about
> it.
> If further details are required, please reply to the NG.
> TIA
> --
> Duncan