Administration Guide > Database Backup > Express installation backup
Express installation backup
An Express installation of Creo Elements/Direct Manager Server (including the Microsoft SQL Server 2005 Express Edition database) is pre-configured to do an automatic database backup at midnight every night. It does a full backup, and overwrites the previous backup files.
An Express installation of Creo Elements/Direct Manager Server using a pre-installed database (any edition of Microsoft SQL Server 2005 or Oracle 10g) does not include an automatic database backup. Consult your Microsoft or Oracle documentation for instructions on how to back up and restore your database.
Where are the Creo Elements/Direct Manager Server backup files saved?
The backup files are saved in
C:\Program Files\PTC\Creo Elements\Direct Manager Server data
(if you installed Creo Elements/Direct Manager Server in the default location).
The database backup (.bak) and backup log (.log) are saved in
C:\Program Files\PTC\Creo Elements\Direct Manager Server data\DB backup
The Creo Elements/Direct Manager Server File Server files are saved in
C:\Program Files\PTC\Creo Elements\Direct Manager Server data\File storage
Can I change the Creo Elements/Direct Manager Server backup schedule?
You can change the backup schedule using the Microsoft Scheduled Task Wizard. See the Microsoft help on scheduling tasks for more information. The backup task name is Creo Elements/Direct Manager Server Backup.
* 
The computer where the database is installed should be up and running 24 hours a day, 7 days a week. That ensures the system can make regularly scheduled backups.
How do I restore a Creo Elements/Direct Manager Server backup?
You can restore a backup using the Microsoft SQL Server Management Studio Express (download it free from the Microsoft web site).
1. From the Start menu, click Programs > Microsoft SQL Server 2005 > SQL Server Management Studio Express.
a. Server name: The Server name should be <your computer name>\SQLEXPRESS. If it isn't displayed, click the pulldown arrow and select Browse for more. In the Local Servers tab, open the Database Engine and select the server that matches <your computer name>\SQLEXPRESS. Click OK.
b. Authentication: Select Windows Authentication.
c. Click Connect.
2. Expand Databases to see WM.
3. Right-click WM and click Tasks > Restore > Database
4. Follow the instructions to restore your database.
* 
Your regular server file system backups include xml files that match the version of the database. These xml files contain information on any customizations made to the database, such as assigning Data Dictionaries or Number Generators. If you do not restore these files, existing xml files may be out of sync with the database. Restore the following files on the server:
C:\Program Files\PTC\Creo Elements\Direct Manager Server 20.6\config\*.xml
C:\Program Files\PTC\Creo Elements\Direct Manager Server 20.6\WebServicesServer\*.xml
Was this helpful?