hello dcpeterson,

please ignore from here.......

_______________________________________________________________

thanks for the response. i am afraid that i ran the script that you gave me against the 'master' database

Hello dcpeterson,

thanks for the response. i dont have any triggers or any foreign keys....could you be a little more specific about the script that you have given above? a step-by-step...

It worked!! Sorry...I made an typo in specifying the logical filename. When I corrected it, it worked!

I just have couple questions though.....

1. what is the file format of the back up...

Thanks for your replies. I changed the RESTORE statement per dcpeterson's reply (ofcoz after ensuring what the logical file names were) and this is the error I get:

Logical...