How to open BCM file(not archived,just *.mdf &*.ldf)?

[pyay2000]

My database was left after system reinslling but I didn't archived it

 

[Luther]

My database was left after system reinslling but I didn't archived it

Those are sql server files. BCM can't open them directly.

 

[pyay2000]

Well.So how to open the databese?Where is it?

Those are sql server files. BCM can't open them directly.

 

[Luther]

Well.So  how to open the databese?Where is it?






- Show quoted text -

The mdf files needs to be attached to the BCM Sql Server instance.

You can attach a database to sql with sql studio (download it from
microsoft.com) or use osql or sqlcmd:
http://beyng.blogspot.com/2006/03/how-to-attach-database-files-to-sql.html

 

[pyay2000]

Really thank you but it's too difficult to me
result are
C:\Documents and Settings\Administrator>OSQL -E -S .\mssmlbiz -d master
-Q"CREAT
E DATABASE MSSmallBusiness ON (FILENAME = 'C:\Documents and
Settings\Administrat
or\Local Settings\Application Data\Microsoft\Business Contact
Manager\MSBusiness
ContactManager.mdf') FOR ATTACH"
[DBNETLIB]SQL Server does not exist or access denied.
[DBNETLIB]ConnectionOpen (Connect()).

 

[Luther]

Really thank you but it's too difficult to me
result are
C:\Documents and Settings\Administrator>OSQL -E -S .\mssmlbiz -d master
-Q"CREAT
E DATABASE MSSmallBusiness ON (FILENAME = 'C:\Documents and
Settings\Administrat
or\Local Settings\Application Data\Microsoft\Business Contact
Manager\MSBusiness
ContactManager.mdf') FOR ATTACH"
[DBNETLIB]SQL Server does not exist or access denied.
[DBNETLIB]ConnectionOpen (Connect()).

What version of BCM do you have? With 2003, use microsoftsmlbiz
instead of mssmlbiz on the osql cmd line.

You can check Windows's list of services to confirm whether the sql
service instance is running.

By the way, I recommend you never login and work as user
administrator. That login is not meant for regular use. If the machine
is connected to the internet, the security risks are tremendous.