Business Contact Manager Team Blog

PingBack from http://business.wpbloggers.com/?p=9923

i have attempted to follow this process, however when I goto start and run and put in  %LOCALAPPDATA%\Microsoft\Business Contact Manager\

I receive an error message that says "WINDOWS CANNOT FIND  %LOCALAPPDATA%\Microsoft\Business Contact Manager\.

What is my next move?

I received the same error so I've got the same question, what next?

I uninstalled BCM2003 and installed BCM2007. Everything looks ok except for the email history . We dont see the old history and there does not seem to be any history being created. Any  help would  be appreciated.Thanks.  tsscontact@yahoo.com . David Solis

We upgraded from BCM 2003 to BCM 2007.  All looked well until we noticed some of the contacts in BCM did not port over.  I have a backup of the old data in the form of SQL 2000 backup, and I have it live on SQL 2005.

How can I convert this old data into the BCM 2007?  Unfortunately, I don't have a .bcm backup, only every other backup.

Are there any good scripts I can use to bring over the missing data?  Any help will be appreciated -- larry@dangelocpa.com

Thank you, Larry Leffler

Our customers don't want to upgrade to Ofice 2007; they want Windows XP reloaded and all their app functionality restored.

I've modified your script for Win XP and BCM 2003, e.g. "C:\Program Files\Microsoft SQL Server\80" instead of "...\90", etc., but the program "sqlcmd.exe" is nowhere to be found, nor does the subfolder ".\MSSMLBIZ" exist.

Do you have an MDF restore solution that works for BCM 2003?

Thanks.

This happens to me at least twice a year with BCM.

something crashes the machie.  This time a bad memory stick

Now BCM will not load and it tells me to start the SQL.  It wont start and tells me to go to a MS web site for help.  I go through the people chatter and try the three things that are suggested.  Uncompresisng a file, directory, running a repair utility, and nothing works.

I cannot get bcm to even start.  Should I have some support package like I bought with ACT $149.00 per year to fix bugs?  This should not be that hard.  And now I have been without a database I need for over a week.  LAst time I had India help it took two weeks to get my $59.00 help to come up with a solution.

Not sure if I am in the right place but having difficulty with BCM and the product and services list.  We have been using Opportunitys to create our quotes which then link to Accounting 2008.  Why if I put new products and services into the list in bcm  they not show in the accounts products and services but does if its done the other way round. And why when you add products or services in the quote itself does not not save to the product and services list.  Input a whole load of info into a quote believing its saving to the list.

Any advice would be gratefully recieved

Thanks  

Hey guys great post, a water main broke at work when they were installing showers floor above.  In our recovery efforts we managed to save the MDF and LDF files which are crucial.  I installed SQL Server 2000 on my new machine and ran the script provided (I'm sorry I accidently overwrote the original .txt result) and here is the .txt result from the second go:

HResult 0x2, Level 16, State 1

Shared Memory Provider: Could not open a connection to SQL Server [2].

Attach DB Returned:1

Msg 1801, Level 16, State 3, Server DAVET\MSSMLBIZ, Line 1

Database 'MSSmallBusiness' already exists. Choose a different database name.

Attach DB Returned:1

Msg 1801, Level 16, State 3, Server DAVET\MSSMLBIZ, Line 1

Database 'MSSmallBusiness' already exists. Choose a different database name.

Attach DB Returned:1

Msg 1801, Level 16, State 3, Server DAVET\MSSMLBIZ, Line 1

Database 'MSSmallBusiness' already exists. Choose a different database name.

Attach DB Returned:1

Now when I start Outlook and goto Database Tools I get,

Starting SQL Server when I select a menu item. Create or select a Database there is no option for my original database MSSmallBusiness, however

If I go into Manage Database, I get an unable to open MSSmallBusiness Operating System Error 5 if I click on the other databases tab.  I did some research to see if I could see why it isn't working, one thing I found odd is when I created a new blank Dbase the following use was in the security for the new .mdf file SQLServer2005MSSQLUser$DAVET$MSSMLBIZ (DAVET\SQLServer2005MSSQLUser$DAVET$MSSMLBIZ)?, but is not nor can I appear to add that user to my original file.

I feel that I am very close!!  Need this data bad! any help would be much appreciated.

The login information as per user is the same but the computer names are different?  Is there an issue in trying to run the Dbase in SQL Server 2000?, when I go into the ENterprise Manager I cannot drop down to the attached databases because it requires SQL 2005, but when I try to install SQL 2005 I have a problem with the instance of SQL 2005 Express?

Thanks

I am using the BCM in XP that came with Office Ultimate 2007.  I didn't knowingly migrate to 2005?  Essentially the Database ran fine on the old computer until it got damaged, I was able to recover the ldf and mdf files.  

I reinstalled the same copy of Office Ultimate on the new laptop I recieved from a coworker.  I have a copy of SQL 2005 and 2000.

Thanks for your help.

BCM Team,

I have the same issue that Mike Bassell mentioned in a previous comment.  I have a clients computer with BCM 2003 and this script does not appear to work.  

Sateesh replied to him but I still don't understand.  Can someone please clarify what exactly needs to be changed in order for the script to work?

Thanks,

- Ben

---------------------------

If you have BCM V2, the SQL instance name is not MSSMLBIZ.  It has a different name starting with MICROSOFT.  Till BCM V2 SP3, BCM shipped with MSDE.  Only from BCM V2 SP4 that MSDE was replaced with SQL Express.

Inorder for the script to work with BCM V2, you need to change the V2 instance name, the location of the MSDE sql exe file, the location where BCM V2 stores the mdf and the ldf files.  Try making these changes and let me know if it works.

--------------------------

BCM Team,

Environment:

XP SP3

Fresh Install of Office 2003 and BCM

Installed BCM SP1

Cannot located the sqlcmd.exe file....

Thanks,

- Ben

I have the same issue with mdf and ldf,

I have them renamed in the local\business manager directory (I renamed them idmachines)

Yet when I go to bcm database tools select it doesn't see idmachines

After I ran the script the idmachines restore result.txt only contained file attach db returned 0

Vista SP1

2007 Outlook 12 and BCM 3

I'm very much a novice at data recovery.  Here's my story:

  I run XP Pro and I upgraded from Office for Small Business 2003 to Office for Small Business 2007. The upgrade went well, including the recognition of my existing BCM files.  But, Outlook 2007 with BCM ran slowly and there was a connectivity issue to my corporate exchange server they haven't de-bugged yet.  

  So I elected to uninstall Office for Small Business 2007 and reinstalled Office for Small Business 2003.  That went well except it won't recognize my BCM .mdf or .ldf files.  

  I spent four and a half hours on the phone with Microsoft's BCM team in southern India yesterday trying to rename the files so they could be recognized in BCM 2003 again.  They gave up on it saying the files were corrupted and are unrecoverable because of the upgrade to 2007, then subsequent reversion to 2003.  I don't buy this explanation yet.

  Any guidance on recovery is greatly appreciated.  I have a few hundred business contacts with related phoncon records, appointments, etc that are quite valuable to my business.

  Thanks for taking a minute to read my sad story and for any assistance that may come of it.  If necessary I'll find someone with lots more chops at this than me to carry out any instructions offered.

  Gary1029

Vinit,

  Thank you for your response.

  A file titled GarysBusinessContactManager.sbb does indeed exist right where you said it would be!  It is dated for the date I performed the upgrade to 2007.  

  How do I restore it so that BCM 2003 will recognize it?  I clicked on Database Tools, Manage Database, and Restore.  It's looking for file extension .msbcm.  The file is currently named GarysBusinessContactManager.sbb.

  Thanks for your assistance.

Gary

Hi BCM Team,

My old laptop was sent off for repair but was lost by the courier.  I am trying to restore my BCM from files I had on the hard drive.

I am not a technical expert but managed to restore it once with the help of my neighbour - however stupidly I then deleted the extra databases (MSSmallBusiness2) and then found that BCM would no longer work.  I have since restored and reformatted the hard drive a couple of times to try a clean reload but have not succeeded.  

The text files that have been created after running the RestoreDB.cmd say

HResult 0x2, Level 16, State 1

Shared Memory Provider: Could not open a connection to SQL Server [2].

Attach DB Returned:1

Attach DB Returned:0

and

HResult 0x2, Level 16, State 1

Shared Memory Provider: Could not open a connection to SQL Server [2].

Attach DB Returned:1

plesae can you help me get back up and running

many thanks

Philip

Greetings.

Being rather unfamiliar with BCM as a whole, I apologize for being rather verbose in this post. We are speaking about Outlook 2003 with the Business Contact Manager installed. Every time we enter Outlook we receive numerous: Managed MAPI Service Catastrophic Failure error messages. Could not initialize CLR. The parameter is incorrect. We have been trying to restore the BCM file. Recently, with the help of this article, we have recovered several important finds. In %LOCALAPPDATA%\Microsoft\Business Contact Manager\ one WILL find the .ldf and .mdf files that are spoken about in this article. In any event, we are trying to restore the BCM file to allow the file to be opened. Now, interestingly enough, we created a ‘Test’ profile on the machine in question in Outlook 2003. The test profile opens with no error messages save an error about Microsoft Office Outlook SMS add-in. However, the second we try to add anything related to the Business Contact Manager file in, for example, Data File Management under the ‘File’ menu, we receive the Managed MAPI Service Catastrophic Failure message repeatedly. What should we do? Should we reinstall Office Outlook 2003? What risk does this pose to losing the Outlook Data files? Also, a separate Office Outlook 2003 version does exist on another computer. I have read here that installing Office 2007 creates a backup of the BCM files on the machine. I do believe that there is a trial version of Office 2007 installed, but I have yet to open Outlook or take a look at that. At the moment, the only concern is the recovery of the BCM file from the ldf and mdf files. They are titled: Prosearch.ldf and Prosearch.mdf. The mdf file is approximately 100,000 kB and the ldf is approximately 15,000 kB.

Moreover, a glimpse in the Control Panel in Add/Remove Programs does not reveal much information about BCM. All that is listed for BCM in add/remove programs applet window is the Business Contact Manager Update for Outlook 2003. We are not that familiar with SQL and simply need assistance restoring this BCM file from these two files.

Any help on this issue is greatly appreciated.