BCM Auto Backup Data and Customizations

Status
Not open for further replies.

shani

Member
Outlook version
Outlook 2013 64 bit
Email Account
POP3
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 ..
 
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.
 

Attachments

  • backupdb.sql.txt
    1.7 KB · Views: 613
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.
 

Attachments

  • bcm database details.png
    bcm database details.png
    117.8 KB · Views: 686
  • Screen Short of directory structure.png
    Screen Short of directory structure.png
    201.5 KB · Views: 668
  • sql error.png
    sql error.png
    152.9 KB · Views: 621
  • sql working without cmd file.png
    sql working without cmd file.png
    109.8 KB · Views: 681
  • RunScript.txt
    122 bytes · Views: 587
  • backupdb.txt
    1.7 KB · Views: 582
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.
 
yes i did changed but its not working ):
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
K Auto-linking emails by default shared DB BCM 2007 on SQL 2008 BCM (Business Contact Manager) 4
T Outlook 2010 BCM Migration to Standard Contacts BCM (Business Contact Manager) 0
R Follow up button doesn't working neither the reminders in BCM BCM (Business Contact Manager) 0
P BCM conditional formatting BCM (Business Contact Manager) 5
B Outlook Business Contact Manager with SQL to Excel, User Defined Fields in BCM don't sync in SQL. Can I use VBA code to copy 1 field to another? BCM (Business Contact Manager) 0
D BCM 2013 not functioning as BCM 2010 Example no drop down for communications history Using Outlook 0
J No access to a Database BCM BCM (Business Contact Manager) 3
J Marketing task MS BCM BCM (Business Contact Manager) 10
S BCM Compulsory field, New opportunity Outlook VBA and Custom Forms 0
A BCM does not work anymore! BCM (Business Contact Manager) 1
G Windows Update Causes BCM Database Access Problem? BCM (Business Contact Manager) 4
A BCM does not work with Windows 10 1703 any more BCM (Business Contact Manager) 3
S BCM Project Task Order BCM (Business Contact Manager) 1
T Lost access to remote BCM database BCM (Business Contact Manager) 4
crazyboy Problems connecting to BCM on Server Using Outlook 2
J Problems connecting to BCM BCM (Business Contact Manager) 16
T BCM 2010 randmoly going offline BCM (Business Contact Manager) 0
M At last a BCM alternative... Outlook Customer Mngr 365! BCM (Business Contact Manager) 0
S BCM view customization BCM (Business Contact Manager) 1
L Cannot Connect to BCM database BCM (Business Contact Manager) 9
A Cannot connect to BCM database BCM (Business Contact Manager) 3
K BCM Reports: Timeout Expired BCM (Business Contact Manager) 0
K BCM hide subfolders BCM (Business Contact Manager) 1
Diane Poremsky Restoring BCM Database After Upgrading Windows Using Outlook 0
J Unable to link email messages in BCM using a single microsoft office 365 account in outlook 2013 BCM (Business Contact Manager) 1
Diane Poremsky Trial/Beta program for BCM replacement BCM (Business Contact Manager) 8
A BCM crashes immediately after start BCM (Business Contact Manager) 2
A Two Problems with BCM BCM (Business Contact Manager) 0
J BCM 2013 displays wrong form for account and business contact BCM (Business Contact Manager) 1
A Latest updates kill BCM 2013 BCM (Business Contact Manager) 0
C Where are BCM User Customizations located? BCM (Business Contact Manager) 9
Diane Poremsky Outlook 2016: No BCM Using Outlook 0
Diane Poremsky Outlook 2016: No BCM BCM (Business Contact Manager) 17
wallisellener BCM and MSSQL2012 BCM (Business Contact Manager) 2
M Can I use BCM projects for this BCM (Business Contact Manager) 1
R BCM Reporting of repeat calendar entries BCM (Business Contact Manager) 0
Eduardo Macias BCM 2013 with SQL Express 2014 BCM (Business Contact Manager) 5
A Upgrade BCM System from 2010 to 2013 BCM (Business Contact Manager) 0
A BCM crashes after Windows 10 update BCM (Business Contact Manager) 1
C BCM Text Boxes & tabs are too short when downloading to Office 365 BCM (Business Contact Manager) 0
jChambler Cant install BCM on windows 10 BCM (Business Contact Manager) 12
S BCM screen Layout BCM (Business Contact Manager) 7
Diane Poremsky BCM Errors after Upgrading to Windows 10 Using Outlook 1
J Missing BCM TAB Main Menu - 2007 BCM (Business Contact Manager) 2
M Modifying BCM Database using Access BCM (Business Contact Manager) 1
jChambler BCM not installing properly with Outlook 360 BCM (Business Contact Manager) 3
S BCM crash Atheros Addin 2010 Using Outlook 1
R Installing BCM BCM (Business Contact Manager) 0
crazyboy Copying BCM database from backed up mounted image to new drive BCM (Business Contact Manager) 2
G Future development of BCM BCM (Business Contact Manager) 5

Similar threads

Back
Top