Hi joshsackett,
Thanks for the advice, I tried the Restore the way you suggested
(through 'From device') only I get the same error.
I'm starting to think that maybe the backup file I have is corrupt, as
I didn't do the original back, plus when I click on View Contents...
after selecting the file I get the following error. 'Error 3013:
RESTORE HEARDERONLY is terminating abnormally.'
I've defiantly got the right DB as I right click and select Restore.
I've even tried it on another SQL Server 2K, with the same results.
Can you think of anything else it might be?
Many thanks,
Rich.
joshsackett wrote:
Be sure you have the CORRECT name next to 'Restore as database:' in
order for these steps to work:
When restoring the database, select the 'From device' radio button.
Then click 'Select Devices...' then click 'Add' then input the file
location and name. Click 'OK', 'OK' and then click on the 'Options' tab
and check 'Force restore over existing database'.
Under 'Restore database files as:' and 'Move to physical file name'
change those folders to the correct location. Click 'OK'.
You will be restoring over your blank database.