Enable FILESTREAM in both the primary and the secondary servers. Each server must be running SQL Server 2008 with FILESTREAM enabled. If any of the required prerequisites are not met, the solution will not work.
Failover clustering: This high availability solution requires FILESTREAM data to be hosted on a shared disk so that it can be accessible by all nodes in the cluster. Each node in the cluster must have FILESTREAM enabled for it to work successfully in a clustered environment.
Replication: In merge replication, a uniqueidentifier data type column is automatically added to tables that does not contain this data type. A UNIQUE constraint must also be defined for the column along with ROWGUIDCOL property set.
When a witness server goes offline, the full quorum is no longer used. Both the principal, and mirror will move into a partner-to-partner quorum. Without the witness server, automatic failover will not be supported. A database administrator will have to perform manual failover if the principal server becomes unavailable. Only when the witness server is back online will the automatic failover be possible.
No comments:
Post a Comment