Device activation error -- sql server msde

sql server msde : Device activation error

jim
4/23/2007 1:28:03 PM

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.

Hari Prasad
4/23/2007 11:40:27 PM

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

[quoted text, click to view]

jim
4/24/2007 1:38:07 PM

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.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server msde

home · blog · groups

Questions? Comments? Contact the dn