Swyx Knowledgebase

HOWTO: Backup and restore the SwyxWare user database (kb2220)

The information in this article applies to:

  • SwyxWare from v3.20 to v4.1x

[ Summary | Information ]


Summary

A backup of the SwyxWare user database can be created with every Microsoft-SQLServer 7 aware backup software or manually by using two VBScripts from the SwyxWare installation CD.

Please note that this backup is not suitable to replicate a SwyxWare on a different machine (e.g. fallback server). More informations on this can be found in the Knowledgebase article:

Replicate SwyxServer user database and folders (kb2519)Note: SwyxWare v4.20 contains a newer backup and restore script version which is described in the SwyxWare Administration manual, chapter 4.13


Information

SwyxWare user database is a SQL database. Per default SwyxWare uses Microsoft Data Engine, a SQLServer 7.0 compatible data engine. It's possible to use any backup software capable of creating backups of Microsoft SQLServer 7 databases. To create a backup manually Swyx provides two VBScripts on the SwyxWare CD in folder \Tools.
 

Backup.wsf

This script writes a backup of the SwyxWare user database to a file. It is used by executing the following on a Windows command prompt:

cscript.exe Backup.wsf [-h|-?] [-o] [-n name] [-d desc] [-s server] [-t timeout] -f filename

 
with

[-n] name Set backup name.
[-d] description Set backup description.
[-s] server Server name. To create a backup on a remote server specify the server name here. Note that the path/filename set with -f must be a local path on the remote server.
[-t] timeout Set timeout for connection to server.
[-o]   Overwrite existing backup(s).
-f filename Filename for backup. Use quotation marks (") if filename contains spaces. You should specify a full path and filename here. This parameter is required.
[-h][-?] help Shows a short command line parameter description

Example:

cscript Backup.wsf -f C:\SwyxWareUserDataBackup.dat


 

Restore.wsf

This script restores a backup of the SwyxWare user database from a file. It is used by executing the following on a Windows 2000 command prompt:

cscript.exe Restore.wsf [-h|-?] [-i] [-n] [-s server] [-t timeout] -f filename


with

[-s] server Server name. To restore a backup on a remote server specify the server name here. Note that the path/filename set with -f must be a local path on the remote server.
[-t] timeout Set timeout for connection to server.
[-i]   Show backup information. Displays all backups stored in the file.
[-n]   valign=top>Do not start server service after restoring data.
[-p] position Select backup position within file. Use this parameter if the backup file contains more than one backup.
[-y]   Do not ask before stopping server.
[-m] path move database file (mdf) to this location. Microsoft SQLServer stores a database in two files, a physical database file ending with .mdf and a transaction log file ending with *.ldf. Microsoft SQLServer stores the physical database file location in the backup and will use these location during restore. If you want to place the physical database file (.mdf) somewhere else during restore, specify the full path here. This is usually necessary if the MSDE/SQLServer is installed at a different folder than at the time of the backup.
[-l] path move transaction log (ldf) to this location. Microsoft SQLServer stores the database transaction log file location in the backup and will use these location during restore. If you want to place the database transaction log file (.ldf) somewhere else during restore, specify the full path here. This is usually necessary if the MSDE/SQLServer is installed at a different folder than at the time of the backup.
-f filename Filename for backup. Use quotation marks (") if filename contains spaces. This parameter is required.
[-h][-?] help Show a short command line parameter description


Example: cscript Restore.wsf -f C:\BackupFile.dat

 

 

An example of how to restore a database to another location can be found in the following Knowledgebase article:

Restore SwyxWare database to different location (kb2086)

 


 

Update 27.01.2004: Added link to article kb2086.

 


 

Update 21.01.2004: Added some more explanation for -m and -l restore options.

 


 

Update 19.08.2003: Removed backupdb.vbs -i option, because restoredb.vbs cannot restore incremental backups

 


 

Update 6.01.2004: changed supported version information and added a hint to the SwyxWare manual which describes the v4.20 backup and restore scripts


Comment

Comment on this article



If we have any follow-up questions, where can we contact you?

E-Mail Address (optional)


Note

This feedback form can't be used for support requests. Those requests must be directed to your Swyx reseller or distributor.


Updates

Created: 28.08.2002


  • 13.01.2006: Script names changes - according to v5.01