Move shared Business Contacts Manager database to different directory

I just realized I made a mistake when installing BCM on our server 2003 standard, I was using my user which is an admin but it installed the bcm database into my documents and settings/user directory which it apparently then automatically shared to all the users on the server which means that now all other users have access to my directory. I want to move the database to the documents and settings/all users directory like it would have done if I'd installed it with the default Administrator account and want to know the best way to do that.
Thanks!
LVL 1
earth-travelerAsked:
Who is Participating?
 
earth-travelerAuthor Commented:
I believe from going through your links I found a free tool that was supposed to disconnect a bcm database, let you move it, and then reconnect it. Now I can't find it and now is when I have time to work on it. Any ideas?
0
 
earth-travelerAuthor Commented:
Actually never mind, I found it again. It's the following that I was trying to find again.

You can shortcut the SQL command steps in the whitepaper by downloading a
free copy of SQL Management Studio for SQL Express 2005. This allows you to
detach a database and move it to another folder on the hard drive or a
different PC. Then, you attach the database in its new location.
0
 
earth-travelerAuthor Commented:
This appeared to require some scripting so I ended up just uninstalling, reinstalling and reimporting my database and deleting the original. I believe I now have things set the way I want.
Thanks for your help!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.