Determining the location of small business manager database

G

Guest

I need to put the Small Business Manager database on a removable drive so I
can take it back and forth between work and home. Does anyone know how to set
the physical location of the database?
 
M

Mark Dormer

To move the BCM database

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.

Thats it.


Regards
Mark Dormer
 
L

Larry

Another option you can try is to do an Import/Export in BCM Format (File >
Import/Export > Business Contact Manager. This way you can keep the two
machines synchronized
Be sure and backup your BCM Databases before doing this in case something
gets overwritten

You can also go to Business Tools > Manage Databases and do a Backup/Restore
between the two machines
*** Restoring a Database will overwrite ALL existing data that currently
resides in that Database

--
Regards,

Larry, [MSFT]

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

Guest

Unfortunately, these instructions conflict with the BCM Backup and Restore
functions. BCM puts restored databases back in the user's "Documents and
Settings" folder, and the location of this can be changed only at
installation time. Even if you move the database off C:, you'll still need
the same free space on C: to restore it.
 
L

Luther

Another conflict is that BCM backup/restore zip/unzip the backup files,
but Mark also provides the OSQL instructions for restoring the
database, so you don't need to restore using BCM. The key thing in this
area is to do everything in BCM or in OSQL, but don't try to mix and
match unless you really understand what's going on

I think Mark deserves the newsgroup post of the month award. The
question has been asked fairly regularly, but usually the answer is a
terse: "Yes. Use osql." So kudos to Mark for typing in all the
instructions.
 
M

Michael Glotzkowski

Dear Mark,

thank you for your solution on how to move the mall business manger database.

It does not work on my computer.

I have Windows Vista Business 32-bit and use MS Office 2007 Outlook with
BCM. How can I move the two database files (name.mdf + name.ldf)? If I follow
your instruction I get the error message "time out - could be that the server
won't allow connection under standard options through remote desktop"! Also
Since I only have one computer I don't have a server. What shall I put for
the server name then?

I want to move the files to a removable hard disc drive, so that I can use
the BCM at home and on my laptop on the road.

Thank you very much in advance for any help.

Michael
 
L

Luther

Dear Mark,

thank you for your solution on how to move the mall business manger database.

It does not work on my computer.

I have Windows Vista Business 32-bit and use MS Office 2007 Outlook with
BCM. How can I move the two database files (name.mdf + name.ldf)? If I follow
your instruction I get the error message "time out - could be that the server
won't allow connection under standard options through remote desktop"! Also
Since I only have one computer I don't have a server. What shall I put for
the server name then?

I want to move the files to a removable hard disc drive, so that I can use
the BCM at home and on my laptop on the road.

Thank you very much in advance for any help.

Michael




















- Show quoted text -

With BCM 2007, the default instance name is different. Instead of
MICROSOFTSMLBIZ, try MSSMLBIZ.
 

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