TeleVantage Backup & Restore

BACKUP & RESTORE:

If you lose your data it is only because you didn’t back it up!

BACKUP:

You need to backup TeleVantage in a way that you can restore it easily. Backing up and restore of the voice files separate from the database or visa-versa will only result in problems because the database contains “pointers” to the files. You need to take a “snapshot” of both the database and voice files at the same time. There are three processes that are required to do this: 1. Use the TVAdmin to back up the SQL Data. 2. Copy this data off the box. 3. Copy the voice files off the box.

If you want to do this with a batch file, here’s a sample: Make sure Pkzip 4.5 is installed! (see below)

Sample batch file:

(explanation in red – do NOT actually enter the stuff in red into the batch file)

cd\

(change the directory to the root)

md c:\backup

(make a backup directory if one doesn’t exist)

c:\”program files”\”televantage administrator”\tvadmin.exe /backup

(automated TeleVantage backup of SQL and the registry)

pkzipc -add=update -dir=full -max -nametype=long -rec c:\backup\vfiles.zip c:\”program files”\”televantage server”\vfiles\*.*

(zip the voice files)

pkzipc -add=update -dir=full -max -nametype=long -rec c:\backup\sql.zip e:\mssql\artisoft\backup\*.*

(zip the TV-SQL backup files)

xcopy c:\backup\*.* p: /Y

(copies the backup files to a mapped shared directory on another server)

Here's just the file:

cd\

md c:\backup c:\”program files”\”televantage administrator”\tvadmin.exe /backup

pkzipc -add=update -dir=full -max -nametype=long -rec c:\backup\vfiles.zip c:\”program files”\”televantage server”\vfiles\*.*

pkzipc -add=update -dir=full -max -nametype=long -rec c:\backup\sql.zip e:\mssql\artisoft\backup\*.*

xcopy c:\backup\*.* p: /Y

Note: Your server may have different paths. Make sure to use the correct paths for your installation. If you want to automate this process, we recommend Launch Pad (see below). Do it at least once a week.

RESTORE:

Make sure, when you reinstall (if you reinstall) that all files are in the original locations. Unzip and restore and files located in c:\mmsql\artisoft\backup directory. Unzip and restore and files located in c:\program files\televantage server\vfiles directory. Restore SQL by clicking “Tools” + “Restore Database” in the TV Administrator – Restore both the database and registry info if prompted

ADDITIONAL NEEDED SOFTWARE:

Get the PKWARE Suite (for Pkzip 4.5 for DOS) ($29.00):

http://www.digitalriver.com/dr/v2/Ec_Main.entry24?SP=10023&PN=1&V1=371158&xid=21760&search_id=8065037&doc_id=2&DSP=&CUR=840&PGRP=0&CACHE_ID=0

Get Launch Pad for Win2K

http://www.cypressnet.com/Download/lp32.zip (c) 2002 True Data Technology