> That still results in the same error. I even went so far as
> to create a new database, use DTS to transfer all objects and
> data, create a backup with the same name, replace that back
> up with the backup from the source and I still got an error
> saying it's a different database. If I select "force restore
> over existing database" I get the "with move" error. When I
> examine the path that you mentioned it points to the correct drive.
> Others have mentioned using DTS. Are there any pitfalls to
> this? I'm glad I'm not in a crisis recovery situation.
You can use DTS for this to simply transfer the data from one server to
another, but I've had better success with the backup/restore method - it
generally is faster, and produces fewer inscrutable errors in my experience.
If you like, simply delete the existing database on the server to which you
want to restore, then try the restore - then, the database will be created
from scratch.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
