Disaster Recovery
Last updated
Was this helpful?
Last updated
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.
Data Stream recommends the use of .
Don't forget to set a backup schedule for each Microsft SQL Agent Job. []
Download the scripts .
When the mirrored database is synchronized, the database owner or system administrator can initiate manual fail-over to the secondary server.
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.
Validation of mirroring status is critical to a successful fail-over. []