...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
Status | ||||||
---|---|---|---|---|---|---|
|
If system resources are enough, we recommend that you perform a full backup of your FactoryLogix database daily.
You use SQL Server Backup to back up a FactoryLogix database. Technically, there are no problems when backing up FactoryLogix databases online—end users and nightly batch jobs can continue to use FactoryLogix applications without problems, even when a backup is in progress.
Info |
---|
...
...
Important |
...
SQL Server Backup consumes only a few CPU resources but does require I/O bandwidth because SQL Server will try to read every used extent to the backup device. (Everything required for FactoryLogix is included in one central SQL database.) |
...
For information about using SQL Server Backup, consult the Microsoft SQL Server documentation. |
Use SAN technology to back up the database
Storage Area Network (SAN)
...
is a specialized, high-speed network that provides block-level network access to storage. SANs are typically composed of hosts, switches, storage elements, and storage devices that are interconnected using a variety
...
of technologies, topologies, and protocols.
To create faster online backups using SAN Technology, SQL Server offers interfaces for SAN vendors to perform a Snapshot Backup or create a clone of a SQL Server database. However, backing up terabytes of data every night may overload
...
your backup infrastructure. A second SAN option is to do a differential backup of the FactoryLogix database daily and a full database backup only on weekends.