How to move BCM database to data drive?

[daugherty.sean]

I'm not familiar with MSDE, I know it isn't supported - but does anyone
know how to go about moving the database to a different drive? I've
done it for Sharepoint, but that SQL Server. Any help would be
appreciated. Actually, it looks like its pretty much hardwired into BCM
to expect the database in its default location. I wonder if theres a
registry edit that can be made?
Thanks in advance,
SD

 

[Lorenz Schallinger]

I'm not familiar with MSDE, I know it isn't supported - but does anyone
know how to go about moving the database to a different drive? I've
done it for Sharepoint, but that SQL Server. Any help would be
appreciated. Actually, it looks like its pretty much hardwired into BCM
to expect the database in its default location. I wonder if theres a
registry edit that can be made?

I'm not sure if the following technique complies to the licensing terms
with BCM2 ...

@MSFT or @MVP : Is this ok regarding the BCM2 license agreement ?


I'm talking about the new update of Business Contact Manager for Outlook
2003 - not the old one - so look for the update if you haven't got it
already.

In fact the BCM MSDE-instance (YOURMACHINE\MICROSOFTSMLBIZ) is _not_
wired to your machine (or a computer with Outlook 2003 installed).

You can move the BCM database to a standard SQL Server or MSDE on any
machine you want to - but you have to make sure that this instance is
running on a specific TCP port (56183 instead of the default 1433).

Then, simply backup your MSBusinessContactManager database with SQLEM or
by command line, copy it to the target machine and restore it - voila.

MS also provides the SQL Scripts to generate the DB by hand, they are
located in the BCM install dir (but I'm not sure if this works)...

 

[SeanD]

Lorenz, thanks for responding. Is there somewhere you could refer me
to, to find out how to simply move the database to drive D:? I'd rather
not become an expert on MSDE just to accomplish this small task. I'd be
happy to post my results for reference. Have you actually moved the BCM
db to a SQL server yourself? Frankly, I'm surprised that moving the
database off C: wasn't included in the update. Thanks much!
SD

 

[Guest]

This is exactly what I want to do, but I haven't been successful yet. I too
am not familar with MSDE, so I don't know how to install the instance in
Services. I merely installed Outlook, then installed BCM update.

I am trying to make the database shareable right now, but I haven't been
successful yet.

Any ideas on how to streamline this whole process?

TIA,

Larry

 

[Diane Poremsky [MVP]]

follow the steps in http://support.microsoft.com/?kbid=843580 to relocate
it. let us know if it works with the BCM db.

if you're moving it to a new machine or replacing a drive...
http://www.slipstick.com/emo/2004/up040708.htm#bcm



--
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Author, Google and Other Search Engines (Visual QuickStart Guide)



Join OneNote Tips mailing list: http://www.onenote-tips.net/

 

[Hawkmoth]

Hi Diane Poremsky

Your suggestion to move the database as described http://support.microsoft.com/?kbid=843580 Worked a treat for me apart from when I attempted to reattach the database.
I had to remove @dbname = , @filename1 = and @filename2=
So the reattach line read:-

EXEC sp_attach_db 'DatabaseName', 'C:\new_database_location\database.mdf', 'C:\new_database_location\database.ldf'

But it worked great.
Thanks