Database Overview
Overview
OpCon uses Microsoft SQL Server as its database. This section covers the configuration and administration topics you need to maintain a healthy OpCon database environment, including high-availability options, failover procedures, backup and restore processes, and routine data maintenance.
caution
Database mirroring and replication changes affect system availability. Schedule these operations during a maintenance window and verify backups before proceeding.
In This Section
| Page | Description |
|---|---|
| Failover Scenarios | Supported failover scenarios and how OpCon behaves during each |
| Manual Setup for Microsoft SQL Replication | Step-by-step guide to configure replication manually |
| Setup for Automatic Microsoft SQL Replication | Using the setup wizard to configure replication automatically |
| Failover and Recovery with Replication | Recovering from a failover event when replication is enabled |
| Setup for Automatic Microsoft SQL Mirroring | Using the setup wizard to configure database mirroring |
| Manual Database Backups and Restoration | Performing manual backups and restoring from backup |
| OpCon Data Maintenance | Purging old history and maintaining database performance |
| Database Mirroring Checklist | Pre-implementation checklist for mirroring setup |
| Database Replication Checklist | Pre-implementation checklist for replication setup |