Link to home
Start Free TrialLog in
Avatar of atekcomputer
atekcomputerFlag for United States of America

asked on

Import .mdf & .ldf file into Outlook 2007 Business Contact Manager

How do you import the .mdf & .ldf files into a new BCM database?

I have a client using Outlook 2007 w/BCM.  His 3.5 GB BCM database is corrupt and I cannot get BCM to work with it.  I created a new BCM database and want to try and import the .mdf & .ldf files into the new DB.  However, the import procedure in BCM does not have .mdf as an option.  How can I import the 3.5 GB DB files into the new one?
Avatar of atekcomputer
atekcomputer
Flag of United States of America image

ASKER

the root problem is when trying to open BCM, this error displays:  

Business Contact Manager database cannot be loaded. Cannot open database "MSSmallBusiness" requiested by the login. The login failed

I have created a new DB, yet how do I get this old database's info imported into the new DB?
SOLUTION
Avatar of Jim P.
Jim P.
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Rick, I read that article initially and I don't have any of the tools they are mentioning in this article. I've installed 2008 Management Studio and none of the tools are there.  Where do I find these?
Jimpen, I've installed SQL 2008 Management Studio.  How do I attach the DB files?
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I have the database attached to SQL 2008 Management Studio, finally!

I've right clicked on the DB and click Export, but there's not "export to text" selection.  The export process (before clicking Finish), displays:
Click Finish to perform the following actions:

Source Location : JIM\MSSMLBIZ
Source Provider : SQLNCLI10
Destination Location : JIM\MSSMLBIZ
Destination Provider : SQLNCLI10

The package will copy 135 tables.

The package will not be saved.
The package will be run immediately.

Not sure if this is what I need to do to get the data exported.
That is one method. It actually will export the data to rebuild it as a new database. Then you can open the files, do a search and replace to change the database name. Then create the new database and import from that.