Trying to reconnect BCM databases in Outlook 2003

[daveparadi]

I had to reinstall my operating system and applications because of a
stupid mistake I made this week. I have the two
MSBusinessContactManager files (.ldf and .mdl) from a backup, but I
can't figure out how to get BCM to recognize them and attach so I get
all my data back. Any help or guidance would be appreciated. I am
running Outlook 2003 on Vista Business and have tried copying the old
file over the new file names but it gives me an error in Outlook.

Thanks

Dave

 

[daveparadi]

I had to reinstall my operating system and applications because of a
stupid mistake I made this week.  I have the two
MSBusinessContactManager files (.ldf and .mdl) from a backup, but I
can't figure out how to get BCM to recognize them and attach so I get
all my data back.  Any help or guidance would be appreciated.  I am
running Outlook 2003 on Vista Business and have tried copying the old
file over the new file names but it gives me an error in Outlook.

Thanks

Dave

By doing research on the developer blog at
http://blogs.msdn.com/bcm/archive/2008/05/19/frequently-asked-question-for-database.aspx,
I fixed my problem. If anyone has this same issue, try the following:
1. Open Outlook in Administrator mode (right-click on the Outlook icon
and click Open as Administrator)
2. Connect the database file you want (it allows this in Administrator
mode)
3. Open a command Prompt by running explicitly as administrator
4. Type sqlcmd -s .\MSSMLBIZ. Hit enter. You will get a 1> prompt.
5. Type use [your bcm database name]. Then type go and hit enter
6. Type sp_changedbowner '[your machinename]\[your login name]'. Then
type go and hit enter
7. Type exit and hit enter to get back to the command prompt
8. Type exit and hit enter to close the command prompt

Hope that helps

Dave