Device activation error

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.
Hello,
If you have the latest backup then RESTORE the DATABASe using RESTORE
DATABASE WITH MOVE options..Try restoring using a new name and make sure
that
dataBase backup is good.
Thanks
Hari
"jim" <jim@.discussions.microsoft.com> wrote in message
news:F3BE2646-3666-40C7-AF83-763ED47957B2@.microsoft.com...
> 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.
>
|||Hi Hari,
Thanks for the response. I just have one more question. With the new
database name, does this mean that the existing database name can no longer
be used on this computer? Or, once the database is restored, I can detach the
database w/ the new database name and then attach the database w/ the old
name in the new location? Hopefully, this question isn't too silly.
your help is appreciated.
"Hari Prasad" wrote:

> Hello,
> If you have the latest backup then RESTORE the DATABASe using RESTORE
> DATABASE WITH MOVE options..Try restoring using a new name and make sure
> that
> dataBase backup is good.
> Thanks
> Hari
> "jim" <jim@.discussions.microsoft.com> wrote in message
> news:F3BE2646-3666-40C7-AF83-763ED47957B2@.microsoft.com...
>
>