G Guy Mar 9, 2006 #1 Is there a way to automate the BCM backup? Can I make is a scheduled task somehow?
L Luther Mar 10, 2006 #2 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.
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.
G Guy Mar 10, 2006 #3 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?
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?
G Guest Mar 10, 2006 #4 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"
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"
