BCM dose not recognize .mdf or .ldf files

[christewart]

Months ago I had a serious problem with my BCM database but I did not
have time to address it. Needless to say it has not been active and I
have been using Outlook 2003 without the BCM component. I would now
like to re-enable BCM but am having a hard time. I have made sure that
it is enabled under Help>About.

When I first had my error i noted that my BCM Database file was not
present in the appropriate folder:

i.e. C:\Documents and Settings\<user>\Local Settings\Application
Data\Microsoft\Business Contact Manager

and the database files that were there were the blank files that you
start with when the BCM add in was first installed.

Now that I want to use the service again I have copied my former backup
files to the local \Business Contact Manager file.

When I run File>Data File Management>Add>Business Contact Manager
Database>Select Database the database name field is blank even though
..mdf &.ldf files are present.

Can anyone shed any light on what i might be doing wrong? I spent a lot
of time building up my BCM and would very much like to salvage what i
can.

thanks in Advance!

 

[Luther]

BCM is asking sql server if there are any databases. sql doesn't scan
the disk looking for .mdf files (they might belong to another instance
of sql). The database has to be explicitly mounted by sql server
for it to be available for BCM to see it.

Mounting a database is straightforward with sql tools, but I'm not
sure how to do it with just bcm and the server installed.

Perhaps someone knows the command for mounting a database from oqsl?

 

[Luther]

There's an example of how to attach database file to sql server here:
http://beyng.blogspot.com/2006/03/how-to-attach-database-files-to-sql.html

 

[christewart]

Hi Luther,

Many thanks for your assistance!

I have tried to attach the database file as mentioned in the post but
am generation the error:

[DBNETLIB]SQL Server does not exist or access denied
[DENETLIB]ConnectionOpen (Connect())

Here is the command line I am using:

C:\OSQL -E -S .\MSSQL$MICROSFOTSMLBIZ -d master -Q"CREATE DATABASE
MSSmallBusiness ON (FILENAME = 'C:\Documents and
Settings\CStewart\Local Settings\Application Data\Microsoft\Business
Contact Manager\MSBusinessContactManager3.mdf') FOR ATTACH"

As 'MSSQL$MICROSOFTSMLBIZ' is the server instance name I found by
looking at my SQL Server service in Services and
'MSBusinessContactManager3.mdf' is the name of the file created during
the last successful backup of BCM.

Do I have this entered wrong?

 

[Luther]

Well, there's typo in MSSQL$MICROSFOTSMLBIZ.

Other possibilities: ensure that service is running and that you are
member of NT's Aministrators group.

 

[Larry]

Try this
Make a note of the names of the existing MDF/LDF Files?
Open BCM and create a new Database with the same name as the existing ones
Close Outlook
Go to Start > Run > Services.msc and start the Services MMC
Stop the MSSQL$MICROSOFTSMLBIZ Service
Replace the NEW .MDF/LDF Files with the prexisting ones
Restart the MSSQL$MICROSOFTSMLBIZ Service
Open BCM and see if your Data is present

--
Regards,

Larry, [MSFT]

This posting is provided "AS IS" with no warranties, and confers no rights.