PC Review


Reply
Thread Tools Rate Thread

BCM 2.0 with SQL and Mobile phones

 
 
=?Utf-8?B?Q2hyaXMgVHJlYW5vcg==?=
Guest
Posts: n/a
 
      2nd Mar 2006
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
 
Reply With Quote
 
 
 
 
Raul
Guest
Posts: n/a
 
      3rd Mar 2006
Check the following link
http://support.microsoft.com/default...b;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.

--
With Regards


Raul Thomas
"Chris Treanor" <(E-Mail Removed)> wrote in message
news:4A71DD85-F70E-4093-BE7A-(E-Mail Removed)...
> 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



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
MOBILE phones michael555 General Discussion 1 2nd Nov 2005 05:42 PM
mobile phones and C# VM Microsoft C# .NET 5 6th Jul 2004 07:44 AM
MicroSky 1.0.43 - A planetarium for mobile phones/cell phones. Gordon Darling Freeware 0 21st Apr 2004 08:10 PM
Mobile Phones and PCs Cyberniv Windows XP Basics 1 31st Jul 2003 09:08 AM
mobile phones Tracey Windows XP New Users 1 30th Jul 2003 11:12 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:30 AM.