Back up and restore your SQL Server databases - j5 - 30 - Installation & Upgrade - Hexagon

j5 Installation and Upgrade

Language
English
Product
j5
Search by Category
Installation & Upgrade
j5 Version
30

Back up and restore is a simple strategy that can be used to restore the standby database to the latest production backup.

For more information about the back up and restore of SQL server databases, refer to Microsoft - Back Up and Restore of SQL Server Databases.

The backup/restore process must be scheduled automatically, and the frequency must be chosen carefully to balance against the performance impact. Frequent backups are desirable, and some data loss is expected, because any production data changes since the last production backup/restore won't be available on the standby server. However, data read writes can be expensive even if done in small chunks, so running a backup job every 15 minutes may not be viable as it may seriously impede server performance. It may be desirable to take system usage into account (for example, schedule a full backup twenty minutes after a shift handover).