Data Stream
  • About
  • Getting Started
  • Installation
    • Server
    • Client
  • Configuration
    • Connectivity
    • Operations / Areas
    • Routing
    • Part Types
    • Serial Number Assistance
      • Scanner
  • Support
    • Definitions
      • Cycle Status
      • Routing Enforcement
      • Routing Configuration
    • Disaster Recovery
      • Client Update Fails
      • Load Balancing
      • Manual Application Restart
    • Workflow Response Codes
    • Contact Us
Powered by GitBook
On this page
  • Microsoft SQL Agent
  • Ola Hallengren Scripts
  • Load Balancing Fail-over
  • Manual Fail-over
  • Automatic Fail-over

Was this helpful?

  1. Support

Disaster Recovery

PreviousRouting ConfigurationNextClient Update Fails

Last updated 6 years ago

Was this helpful?

Data Stream as a stand alone product is not disaster tolerant but works in conjunction with industry leading products to form a disaster recovery process.

Disasters are never a planned event but planning for one is critical to minimizing impact.

Microsoft SQL Agent

Data Stream recommends the use of .

Don't forget to set a backup schedule for each Microsft SQL Agent Job. []

Ola Hallengren Scripts

Download the scripts .

Load Balancing Fail-over

Manual Fail-over

When the mirrored database is synchronized, the database owner or system administrator can initiate manual fail-over to the secondary server.

USE master;
GO

ALTER DATABASE [DataStream] SET PARTNER FAILOVER;

Automatic Fail-over

Automatic fail-over occurs when the fast startup is disabled and computer is properly shutdown.

Automatic fail-over will not occur in a loss of power disaster.

Disabling Fast Startup

Validation of mirroring status is critical to a successful fail-over. []

Ola Hallengren Scripts
Reference
here
Once you have successfully executed the Ola Hallengren Scripts, the Microsoft SQL server agent should contain the following jobs.
Reference