BCM 2.0 with SQL and Mobile phones

G

Guest

Any assistance would be greatly appreciated. Does anyone have experience with
BCM 2.0 for 10-15 users and 7500+ contacts? Have you upsized the MSDE
instance for BCM to SQL? Have you used the Mobile phone add-in for BCM 2.0?
How is this working for you?

Thanks

Chris
 
R

Raul

Check the following link
http://support.microsoft.com/default.aspx?scid=kb;EN-US;224071
Also try the following steps
1.Locate the MSDE database files MSBusinessContactManager.mdf and
MSBusinessContactManager.ldf. By default, these files are located in the
following folder:
C:\Documents and Settings\username\Local Settings\Application
Data\Microsoft\Business Contact Manager

2.Click Start, click Run, type cmd, and then press ENTER.

3.Start the Osql.exe tool. To do this, type osql -E -S
ServerName\InstanceName at the command prompt, where ServerName is the name
of the server where the MSDE database files are located, and where
InstanceName is the name of the instance of MSDE, and then press ENTER.

Note By default, the instance name is MICROSOFTSMLBIZ

4.At the osql command prompt, back up the existing database. To do this,
type the following at the osql command prompt
BACKUP DATABASE MSBusinessContactManager TO DISK = 'PathName'
where MSBusinessContactManager is the name of the MSDE database, and where
PathName is the path and file name that you want, such as
C:\MSDE\Backup\bcm.bak.

5.Type GO, and then press ENTER.

6.Repeat steps 4 and 5 for each database if you have created any extra ones.
Default is just the single database.

7.Detach the BCM database. To do this, type EXEC sp_detach_db
'MSBusinessContactManager' at the command prompt and then press ENTER.

Note If you receive a message that the database is in use and cannot be
detached, start a new command prompt. At the new command prompt, type the
following, and then press ENTER after each line:

net pause mssql$MICROSOFTSMLBIZ
net continue mssql$MICROSOFTSMLBIZ

8.Start another command prompt, or start Microsoft Windows Explorer, and
then copy both of the MSDE database files that you located in step 1 to the
new folder that you want.

9.Attach the configuration database. To do this, type the following at the
command prompt where the Osql.exe tool is running
EXEC sp_attach_db @dbname = N'MSBusinessContactManager', @filename1 =
N'C:\new_database_location\MSBusinessContactManager.mdf', @filename2 =
N'C:\new_database_location\MSBusinessContactManager.ldf'
where new_database_location is the folder where you moved the configuration
database files in step 9.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top