Moving database and repositories

  • Thread starter Thread starter Trung
  • Start date Start date
T

Trung

I would like to move the XPe database and repositories to a network folder.
I've been asked by my IT guy to move it to the network folder because it can
be backup daily. I'm able to move the repositories but I cannot move the
database. I saw previous posts saying to use SQL Enterprise Manager to
detach/attach the database. I do not have this tool. Where can I get this?
Is there another way to do it or do I have to reinstall XPe Studio, QFE, and
reimport all the SLDs?

Thanks in adavance for the help.

Regards,
Trung
 
Trung,

Enterprise Manager is a part of the SQL Server installation (not MSDE). You
may ask your IT if they have one installed anywhere on network (most likely
they do), and use it to remotely connect to your XPe DB to deattach/attach
from it.

In order to move the DB, you have to deattach from it and attach from a new
location.
I am not sure if such MSDE API exist to perform the attachment/detachment
but you can search in MSDN for it.

KM
 
Back
Top