Disaster Recovery
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.

Once you have successfully executed the Ola Hallengren Scripts, the Microsoft SQL server agent should contain the following jobs.
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 occurs when the fast startup is disabled and computer is properly shutdown.
Automatic fail-over will not occur in a loss of power disaster.

Last modified 4yr ago