Hello,

I'm attempting to upgrade from MSDE 1.0 to MSDE 2000. However, before
removing MSDE 1.0, a database apparently was not properly detached after
attempting to attach (using sp_attach_db not attach w/ single file) this very
database to MSDE 2000.

The following error is rec'd:

"Can not create file C:\Program Files....\MyData.LDF because it already
exists.
Could not open new database "MyData". CREATE DATABASE is aborted.
Device activation error. The physical file name "C:\MSSQL7\Data\MyData.LDF
may be incorrect."

Should I attempt to place the log file back to its old location, restore the
database and then detach or should I try to shrink the file and truncate the
log?

Just want to know before I further screw things up.

any help is appreciated.