Back Up Files in Business Contact Manager

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am aware that you can backup BCM from the Business Tools menu choice.
However, I wish to set up my automated back up system so that the individual
files & databases (all of them) used by BCM would be backed up every night
when all of my other files are backed up. How can I get a list of all the
files used by BCM? I am using Outlook 2003 Professional Edition with BCM.

Thank you.

Chris
 
Create a batch file with the following:

osql -E -S .\microsoftsmlbiz -d MSBusinessContactManager -Q "backup database
MSBusinessContactManager to disk = 'C:\FilePath\BCM.bak' WITH INIT"

Then create a schedule for the backup batch file. This overwrites the
orginal file by using the WITH INIT argument.
 
Hi,

I tried this and was able to create a backup file with the batch file but
when I go to restore the file I get an error message "The backup file has
invalid file format"
 
I haven't verified if the restored file actually works but you would need to
restore this file using SQL too, not within BCM.

osql -E -S .\microsoftsmlbiz -d MSBusinessContactManager -Q "restore
database
MSBusinessContactManager from disk = 'C:\FilePath\BCM.bak' "

I would try that and verify if the data is OK afterwards. Of course, I would
backup any files within outlook's tool first in case something goes wrong.
 
Hi Guy

I have tried the same option earlier for BCM but does not work :(.Would be
great if we could get it to work

Regards

Raul Thomas
 
I don't use it myself so I never really verified if a restore would actually
work or not. I noticed the native SQL backup is significantly larger than
the one generated within Outlook. I decided to simply create a daily task to
remind me to do a backup. It isn't worth the hassle.
 
Hi Guy,

Thanks for the tip but when I go to restore I get an error message"exclusive
access could not be obtained because database in use. I tried stopping the
SQL service but with no luck
 
Back
Top