reefshark (7/8/2009)
I kept getting an error. (why do I keep getting errors with everything I do?!?)
as Lynn says, you need to restore the database full backup with NORECOVERYas follows
RESTORE DATABASE mydata FROM DISK = 'D:\somepath\somefile.BAK'
WITH NORECOVERY
then restore the last differential (differentials are accumulative, so only the last needs applying)
RESTORE DATABASE mydata FROM DISK = 'D:\somepath\somefile.BAK'
WITH RECOVERY
shout back if you're still stuck
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉