PDXpert PLM Software
On-line Help Guide
This help topic describes the current PDXpert PLM release. Earlier releases may be different. To view your release's version of this topic, open PDXpert and press the F1 key or select the Help menu.
Back up the database
You should back up your database frequently to insure against data loss.
Microsoft recommends backing up a SQL Server database to an internal fixed drive. The operation may fail — possibly without any warning — if you select a compressed, network-mapped, or external volume. Verify that a backup that's saved to the selected device can be restored.
Microsoft SQL Server databases are not backwards compatible. A database backup can only be restored into the same, or higher, SQL instance. For example, SQL Server 2012 (version 11.0) can restore an 11.0 database, as well as upgrade an older SQL Server 2008 (10.0) database. It can't "downgrade" a higher-level database backup from SQL Server 2014 (12.0).
The PDXpert Application Server may automatically purge files or folders within its working directory. Do not add files to the server's \Data\ folder or its subfolders, since unrecognized files may interfere with proper operation or be deleted.
Using the manual backup tool §
On the PDXpert Application Server window:
Click on the Manage tab.
In the Maintenance area, click the button to open the Save Backup As dialog.
The default backup format is Database with Library (*.pdxz). This is a simple way to save your database and all library files into a single compressed ("zip") file. The file contains the SQL Server backup (.BAK) file, an XML manifest file, and the library file attachments.
The PDXZ format is convenient as you're starting out, but it's intended only to support smaller systems. Use a commercial backup solution before the \Data\Database\ and \Data\Library\ subfolders reach 1GB. See Automating your backup, below.
The alternative backup format is Database without Library (*.bak). This saves the "raw" SQL Server database without including the library files. This is a much faster backup, and is useful for maintenance, but is incomplete without the file attachments.
To have a complete backup, you must use Windows or a backup tool to copy all of your library files that are stored in the \Data\Library\ subfolder.
If more than 2GB of files are in the \Data\Database\ and \Data\Library\ subfolders, you can only save the SQL Server database without the library files. This will be indicated by the DATABASE ONLY - NO LIBRARY (*.bak) format type.
Choose the location where you want your backup file to be saved, and click thebutton.
The backup database file does not carry any security restrictions, and includes your software license key. It may be loaded into another PDXpert instance, and the database component can be extracted and loaded into any SQL Server database engine. Secure your backups to prevent unauthorized access to archival data.
The backup file name includes information about the correct SQL Server version (like ...-13_0.bak). Before the backup database is restored, the file name's SQL Server version is compared to the installed instance to warn of incompatibility.
To restore the backup, see the Restore data from a backup help topic.
Automating your backup §
Your server backup software must be compatible with SQL Server. Consumer-grade backup utilities may not be capable of correctly backing up a SQL Server database, and can even damage or delete your original database. Search the web for sql server backup software. Some less-capable tools may back up the SQL Server database only, and you may need a separate utility for backing up the files contained in the library folder.
It's very important to have a scheduled backup process that automatically saves the database and the library to a safe archive. As your database and file library grow, the compressed .PDXZ backup file will take longer to finish, consume more system resources, and be increasingly vulnerable to file system errors.
Data that must be backed up §
There are two essential PDXpert data components that you must protect:
- the SQL Server database in which all of the product data is maintained (for example, files like PDXpertDB.mdf and PDXpertDB_log.ldf), and
- a Windows folder, called the \Library folder, that contains all files that have been attached to PDXpert's items.
Both of these data elements work together, and therefore they must be backed up at the same time.
Finding the data to be backed up §
The options are:
- Back up the entire server computer.
- Back up the entire disk drive that contains the PDXpert \Data\ folder.
- Within the disk drive, back up the entire content of the \Data\ folder.
- Within the \Data\ folder, back up only the
content of these two folders:
- SQL Server database files: \Data\Database\
- PDXpert library files: \Data\Library\
The disk drive and the location of the data folder are displayed on the PDXpert Application Server's Manage tab.
Automation practices §
Regularly assess your backup & recovery risks, procedures and technologies. Develop and maintain a robust data backup and disaster recovery plan in consultation with your IT specialist. Always validate the results of a new or revised backup procedure.
Your Windows operating system may have the necessary software utilities to create and maintain a reliable backup procedure. There are also many commercial tools available to perform this important task. When developing your data backup and disaster recovery plan, consider these practices:
- Schedule backups to accommodate user activity: backup jobs consume significant I/O resources.
- Ensure that the backup interval reflects how quickly your data ages, and balance this interval with users' time to reproduce lost data after the most recent backup's been restored.
- Avoid propagating viruses by scanning file attachments before saving them into the library.
- Some antivirus software can interfere with the PDXpert Application Server, and should be tested for problems while users perform normal database and library file tasks.
- Do not use your production database/library disk as the primary backup device. Use a separate physical disk and not simply a partition on the same disk.
- After a backup is complete, copy the backup file(s) from the primary backup drive to a secondary device. This secondary device should be secured, and logically and physically separate from the production network. Use disk-to-disk or disk-to-cloud technology for secondary backups. Avoid tape.
- If you don't control your off-site storage location, consider encrypting your saved data.
- To minimize downtime, ensure that off-site backups can be retrieved quickly.
- Don't be too aggressive in purging old backups. In a very large historical file library, a monthly snapshot going back a few years may provide that one crucial file that was corrupted long ago but only recently discovered.
- Periodically verify that your hardware, particularly disk subsystem, is functioning properly.
- Test the data integrity of your backup process by restoring the backup file(s) into a fresh configuration. Regularly validate that the backup process is creating fully-restorable backup files.
Help Guide Contents [PDF]
- 0001. Welcome!
- 0002. Help conventions
- 0100. PDXpert Application Server
- 0101. Server overview
- 0200. How to...
- 0300. Console reference
- 0400. How to start the PDXpert client
- 0500. Program concepts
- 0600. How to set up PDXpert
- 0700. How to use the Item Explorer
- 0800. How to use the Collection Explorer
- 0900. How to work with documents
- 0901. Manage documents
- 1000. How to start a document
- 1003. Fill in the new document
- 1004. Add or remove references
- 1005. Save your document
- 1006. Remove your document
- 1007. Release your document
- 1008. Manage a released document
- 1009. Revise a released document
- 1010. Cancel a released document
- 1100. How to work with parts
- 1101. Manage parts
- 1200. How to start a part
- 1203. Fill in the new part
- 1204. Add, modify or remove BOM parts
- 1205. Import a CAD BOM
- 1206. Add or remove approved sources
- 1207. Add or remove references
- 1208. Save your part
- 1209. Remove your part
- 1210. Release your part
- 1211. Revise a released part
- 1212. Manage a released part
- 1213. Cancel a released part
- 1300. How to revise multiple markups
- 1400. How to work with change forms
- 1401. Processing a change
- 1402. Originate a new change form
- 1403. Analyze a submitted change
- 1404. Fix change processing errors
- 1405. Remove your change form
- 1406. Review a routed change
- 1407. Resolve an on-hold change
- 1408. Analyze an accepted change
- 1409. Use a released change
- 1410. View a completed change
- 1411. Analyze a stopped change
- 1412. View a rejected change
- 1413. Remove a canceled change
- 1414. Return a submitted change
- 1500. How to work with file attachments
- 1600. How to report, import & export
- 1601. Create a report
- 1602. Export a PDX package
- 1603. Use the Report/Export Wizard
- 1700. Import & update items
- 1701. Initialize your PLM database
- 1702. Use the External Data Importer
- 1703. Item Master import
- 1704. Iteration-level relational imports
- 1705. Bill of materials import
- 1706. References import
- 1707. Revision files import
- 1708. Sources import
- 1709. Item-level relational imports
- 1710. Item files & links import
- 1711. Materials import
- 1712. Groups collection import
- 1713. Materials collection import
- 1714. Organizations collection import
- 1715. Persons collection import
- 1716. Custom collection import
- 1800. View & export via ODBC
- 1801. View database objects
- 1802. Create an ODBC connection
- 1803. ItemViews reference
- 1804. ReferencePairViews reference
- 1805. SourcePairViews reference
- 1806. SourceItemMasterView reference
- 1807. StructurePairViews reference
- 1808. ChangeViews reference
- 1809. ChangePairViews reference
- 1810. FilePairMasterView reference
- 1900. How to perform other tasks
- 2000. Menu reference
- 2100. Item Explorer reference
- 2200. Document window reference
- 2300. Part window reference
- 2400. Change Form window reference
- 2500. System Rules reference
- 2501. System Rules window
- 2502. General: Copy files to snapshot
- 2503. General: Item uniqueness definition
- 2504. General: Reviewer's comment required
- 2505. Default File Access
- 2506. Password Policy
- 2507. References Tabs
- 2508. BOM: Allow duplicate parts
- 2509. BOM: Lock part default unit of measure
- 2510. BOM: Allow partner parts
- 2600. Collections reference
- 2601. Managing collections
- 2602. Custom attributes
- 2700. Places/Organizations/Persons
- 2800. General
- 2900. Documents
- 3000. Parts
- 3100. Changes
- 3108. Custom collections
- 3200. Other reference topics
- 3300. Software licenses & legal notices