59 62 134 D 3407
168
D 3407
.
208.01.10
.
02 07.2009
7 Appendices
Sirona Dental Systems GmbH
Backup copies
Operator’s Manual SIDEXIS XG
7.2.1
Database backup
Explanation
As a rule, data on a database server cannot be backed up on a file basis.
Therefore, it is recommended to backup a database into the image data folder
\PDATA within a separately created folder\DBBackup.
By doing this, during backup of the image data folder the database will be
backed up automatically as well.
7.2.1.1
Example: SQL Server 2005
Explanation
During the standard installation of SIDEXIS XG version 1.6 or higher, SQL
Server 2005 Express will also be installed and the database
"PDATA_SQLEXPRESS" will be created.
This installation is used to illustrate the database backup procedure.
Prerequisite
The backup has to be carried out on the computer where the database
resides.
In addition to the database "PDATA_SQLEXPRESS" the "Master" database
should be backed up as well.
● The database "Master" contains user and password information.
Backup
SIDEXIS XG provides the "NGSQLBackup.exe" application to backup the
databases "PDATA_SQLEXPRESS" and "Master".
● It is found on the SIDEXIS XG installations CD in the directory
\Tools\NGSQLBACKUP
.
● This directory also includes a text file (readme.txt) with a detailed
description of the application.
Tip
The data backup can be automated by creating a batch file with the
commands described here and then having it periodically executed via
"Scheduled Tasks" in Windows.
7.2.1.2
Other database servers
Consult the manufacturer of your database server for more information about
data backups and data restorations.
7.2.2
File-based backup
Prerequisite
The database was backed up before. See Section "File-based backup [
NOTICE
The backup must be carried out via the database server being used.
NOTICE
Important additional information
Creating a backup copy must not be confused with relocation.
