database restore issue

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
JayHi,
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
>