Moved 'Windows Embedded Data' folder; Now can't connect to database

[Mark]

I got a new hard drive for my XP Embedded build workstation, and
decided to move the whole Windows Embedded Data folder to it. Now when
I open up Component Database Manager, I get an error saying it can't
connect to the database. I looked in the Event Viewer, and I found
that the MSSQLSERVER service is still trying to open E:\Windows
Embedded Data\MantisSQLDB_Data.MDF, while the file is now located on
drive I: (the new hard drive). How do I reconfigure MSSQLSERVER to
find the XP Embedded database on drive I: instead of E:? I couldn't
find anywhere to set this from the SQL Server Service Manager. Any
help would be much appreciated as I can't build new images anymore!
Thanks!

-Mark

 

[KM]

Mark,

You can't jut move the .MDF file. If you have MS SQL Server Enterprise
Manager, you will just need to detach the Mantis Database, move your .MDF
file (as better move along with the .LDF file) to another drive and then
attach the database again from the Enterprise Manager. I did that and it
worked great.

KM,
BSquare Corp.

M> I got a new hard drive for my XP Embedded build workstation, and
M> decided to move the whole Windows Embedded Data folder to it. Now
M> when
M> I open up Component Database Manager, I get an error saying it can't
M> connect to the database. I looked in the Event Viewer, and I found
M> that the MSSQLSERVER service is still trying to open E:\Windows
M> Embedded Data\MantisSQLDB_Data.MDF, while the file is now located on
M> drive I: (the new hard drive). How do I reconfigure MSSQLSERVER to
M> find the XP Embedded database on drive I: instead of E:? I couldn't
M> find anywhere to set this from the SQL Server Service Manager. Any
M> help would be much appreciated as I can't build new images anymore!
M> Thanks!

M> -Mark

 

[Mark]

Hello,

How do I do this without MS SQL Server Enterprise Manager? I don't
have this. Where can I get it? I assume it's not a free download as I
googled that and couldn't find anything regarding a free download. Any
other ideas before I try to move files back/reinstall?

-Mark

 

[Mark]

Hello,

How do I do this without MS SQL Server Enterprise Manager? I don't
have this. Where can I get it? I assume it's not a free download as I
googled that and couldn't find anything regarding a free download. Any
other ideas before I try to move files back/reinstall?

-Mark

 

[KM]

Mark,

I don't know of any other ways to move a MS SQL database file. In my
understanding, it should be detached first.
If you can't get Enterprise Manager, you may want to search google for a
free utility that does the job. I've never heard of such utility, though.
However, I am not an expert in MS SQL Server so you may want to post this
question to more related newsgroup (microsoft.public.sqlserver.server,
microsoft.public.sqlserver.programming).

KM


M> Hello,

M> How do I do this without MS SQL Server Enterprise Manager? I don't
M> have this. Where can I get it? I assume it's not a free download as I
M> googled that and couldn't find anything regarding a free download.
M> Any other ideas before I try to move files back/reinstall?

M> -Mark


M>>> I got a new hard drive for my XP Embedded build workstation, and
M>>> decided to move the whole Windows Embedded Data folder to it. Now
M>>> when
M>>> I open up Component Database Manager, I get an error saying it
M>>> can't connect to the database. I looked in the Event Viewer, and I
M>>> found that the MSSQLSERVER service is still trying to open
M>>> E:\Windows
M>>> Embedded Data\MantisSQLDB_Data.MDF, while the file is now located
M>>> on drive I: (the new hard drive). How do I reconfigure MSSQLSERVER
M>>> to find the XP Embedded database on drive I: instead of E:? I
M>>> couldn't find anywhere to set this from the SQL Server Service
M>>> Manager. Any help would be much appreciated as I can't build new
M>>> images anymore!
M>>> Thanks!

M>>> -Mark