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...
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: