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 ..
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
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: 319

shani

Member
Outlook version
Outlook 2013 64 bit
Email Account
POP3
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: 350
  • Screen Short of directory structure.png
    Screen Short of directory structure.png
    201.5 KB · Views: 322
  • sql error.png
    sql error.png
    152.9 KB · Views: 352
  • sql working without cmd file.png
    sql working without cmd file.png
    109.8 KB · Views: 354
  • RunScript.txt
    122 bytes · Views: 283
  • backupdb.txt
    1.7 KB · Views: 315

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
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

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

Top