Hi Team,

I happen to get my .mdf and .ldf file from a BCM 2010 system after a crash, I wanted to import .mdf and .ldf file into other Outlook BCM 2010 system

I have tried the below ways but i was unsucessfull

Placing the .mdf and .ldf file in the Default directory of BCM C:\Users\%username%\AppData\Local\Microsoft\Business Contact Manager

Then i renamed the file of database to the orignal name of the database which is in second machine
the default database was MSSmallBusiness.mdf so i renamed the database which i have copied from the different machine to the same name i.e MSSmallBusiness.mdf
then i open Outlook as Administrator but it does not work
I tried to disable services of BCM and then enable it and then open outlook it ask at startup to create a database or connect to existing but when i click on Existing then it does not shows the database which i have copied

I happen to find another solution for moving the .mdf file which is below

http://www.howto-outlook.com/howto/backupandrestorebcm.htm#bcmdisasterrecovery

in the above link it states that i have to install the SQL server management studio and then open attach the same database and few more steps but the issue here is, when i open SQL server management studio and then it connects to the same database engine which is in the machine of BCM and opens the same instance, i find the orignal database over there but i cannot delete it and the main step of attaching the database is not happening.

Do any body have any other solution to this issue? or do i have to follow the same link?

Hi,

After a bit of research, I found this thread might be helpful for you. Quote the related part here:

Since our BCM database is already detached, we need only attach it
again.

But, before we try that, we remove BCM off the system
altogether.

After making sure that BCM was fully removed from the system,
we reinstalled it.

Run services.msc to verify that the MSSSQL (MSSMLBIZ)
database instance is up. Do not run Outlook yet because the BCM will try and
initialize a new database during its setup phase.

The databases would be
located in: C:\Documents and Settings\%username%\LocalSettings\Application
Data\Microsoft\Business Contact Manager\MSSmallBusiness.mdf.

We copied
the recovered database and log files into the above location.

From there,
we ran the following at the command line (assume Enter after each
line):

1. hostname (system will reply with the name of your computer)
2. osql -E -S MyComputer\MSSMLBIZ (assume MyComputer is your hostname)
3. use master
4. go
5. sp_attach_db 'MSSmallBusiness','C:\Documents and
   Settings\Administrator\Local Settings\Application Data\Microsoft\Business
   Contact Manager\MSSmallBusiness.mdf','C:\Documents and
   Settings\Administrator\Local Settings\Application Data\Microsoft\Business
   Contact Manager\MSSmallBusiness.ldf'
6. go
7. quit

Note that osql can be run from within the database folder
because the SQL binn folder resides in the System Path.

Once we had a successful database and log file attach to the MSSMLBIZ instance and fired up
Outlook, all of the BCM content was there.

We then imported the recovered
PST file and our client was good to go.

UPDATE
2008-10-15: If you get an access denied error on the
attach attempt then BCM is not installed properly. Run BCM, create a new set of
dbs (generally MSSmallBusiness2), and then uninstall BCM, copy the original dbs
into the directory, and attach again.

i found the same and i have tried this yesterday but when i run the command of osql - E etc etc i get the error of osql driver not installed and cannot find the drivers. 

do you have any idea from where to run this command?  i found the binn folder under sql sever under programs file. 

do you know Complete step to run it

Hi,

Where did you run the command? From the description, I think the author mean to run the command from the folder which contains the data file you copied. Shift+right click the folder -> open command window here. Let me know if it works. Thank you.

Now i have tried it, running from the location where BCM database is stored that is the default location of BCM data files

C:\Users\Qureshi\AppData\Local\Microsoft\Business Contact Manager

which gives the same error while running from 

C:\Program Files\Microsoft SQL Server\100\Tools\Binn '' 

[ODBC Driver Manager] Data source name not found and no default driver
specified

Below is the command which i have ran

C:\Users\Qureshi\AppData\Local\Microsoft\Business Contact Manager>osql -E -S Qu
eshi-PC\MSSMLBIZ
[ODBC Driver Manager] Data source name not found and no default driver
specified

Hi,

Have you remove the BCM from the system and reinstall it before trying those steps?

Yes I have tried that step

Based on the error message, could you check if sql driver is in place in your system:

1. Open Control Panel->Administrative tools

2. Select ODBC Data Source 32-bit or 64-bit (Depends on your BCM, if you are using Office 32-bit, please select 32-bit)

3. Click on Driver tab, check if sql driver is availabe in your system.

If it's not there, please download it from here, then re-run the script.

Let me know the result, thank you.

I have tried to install the ODBC drivers but still i am getting the same error

Is there any different method to do this? 

Thank you for trying hard i really appreciate it

Hi,

From the error message you got, please check sp_attach_db 'MSSmallBusiness' is the same as *path*\MSSmallBusiness.mdf' and MSSmallBusiness.ldf. As it worked fine from my side.

Meanwhile, as you've installed the sql driver,please remove BCM and re-install, then try that script one more time. Let me know the result, thank you.