My backup was also not good...and the

RESTORE dbname

WITH RECOVERY

did not work either, it keeps saying "incorrect syntax near the keyword with" ?? It doesn't turn up in the database...

Thanks...but it didn't help, i think the database need sto be replaced with an old copy of it...

Roy

Yes, correct, it says LOADING, and i haven't done anything to start a restore.

But here' comes a real newbi question! Where do i type :

RESTORE dbname

WITH RECOVERY

?

Roy