BCM Auto Backup Data and Customizations

[shani]

Hello

Is it possible to create a windows task that runs every 3 hours , backups and export BCM data and settings to a file automatically ? I want to Backup all my BCM data and customization on my SDcard/USB every 3 hours.

Or any software/utility that does it ? I found many utility that backup outlook data but cannot find one that does BCM data toO ..

 

[Diane Poremsky]

BCM runs in SQL, so you should be able to...

I use a bat file with this in it:
REM Run TSQL Script to backup databases
sqlcmd -S Baloo -E -i"E:\SQLBackUp\scripts\backupDB.sql"

and have that set up in task scheduler. It runs the attached sql file (remove .txt from the filename to use it and change the db name and paths.) ETA: actually, it backs up all db, so you only need to change the path to save.

 

[shani]

Thank you for the response .. I am getting few error .. Please know that I dont know anything about sql but i am trying to follow as much as i can .. Please check my errors of screen shorts .. and my files .. .. I think i am not able to follow you correctly on backupdb.sql .. please help and guide .. thanks

BCM runs in SQL, so you should be able to...

I use a bat file with this in it:
REM Run TSQL Script to backup databases
sqlcmd -S Baloo -E -i"E:\SQLBackUp\scripts\backupDB.sql"

and have that set up in task scheduler. It runs the attached sql file (remove .txt from the filename to use it and change the db name and paths.) ETA: actually, it backs up all db, so you only need to change the path to save.

 

[Diane Poremsky]

Did you change this to a valid path? ''D:\SQL-BackUp\'
If so, I will need to test it with BCM - there could be other issues that prevent it from working.

 

[shani]

yes i did changed but its not working ):

 

[Diane Poremsky]

I'll test when i get back into my office - if i don't post back by Tues morning, remind me.

MSDN has this script - Restoring an Automatic SQL Backup – Business Contact Manager Team Blog

Both mine and this one back up the actual database - they bypass the BCM method and backup the actual SQL DB.

 

[shani]

Hello ..

Its a Reminder