BCM Backup

[Guy]

Is there a way to automate the BCM backup? Can I make is a scheduled task somehow?

 

[Luther]

You can use the NT Task Scheduler (in Control Panel) to automate any
command.

You'll have to figure out the osql, or similar, command to fire off a
backup, and then add it to Task Scheduler.

 

[Guy]

That I can do but I can't seem to connect to the database using osql. Does
it allow NT Authentication? If not, does anyone know the SQL login for BCM?

 

[Guest]

BCM only uses NT auth.

This osql command works for me on the same machine as the db and may help you:
osql -E -S .\microsoftsmlbiz -d MSBusinessContactManager -Q"SELECT COUNT(*)
FROM ContactCategoriesTable"