info@dataera.com.tr
+90 216 706 30 80
Dataera > MsSQL > MsSQL
mssql-logo-1

MsSQL

We provide consulting, training, maintenance and outsourcing services for Microsoft SQL server disaster recovery center and high availability solutions.

 

Microsoft SQL Server FailOver Cluster

High availability solution that can be set at the instance level in the same cluster. There is no disk redundancy at the database tier because the same disks are mounted.

With automatic failover, SQL service can be moved automatically from failed nod to other nodes. It can only be done at instance level and can not open in read only mode.

Microsoft SQL Server Database Mirroring

Can not open in read only mode also. Snapshot needs to be taken to read data. It should be set sync for high availability and async for disaster recovery solution. Database level mirroring is possible.

If you have a large number of databases, you should repeat the operations for each one separately. Active and passive servers have disk redundancy because they keep their data on their disks. Microsoft has decided not to continue this resolution.

Microsoft SQL Server AlwayOn

Can be set by creating groups at database level. Passive node can be open read/only mode. Active and passive servers have disk redundancy because they keep their data on their disks and it has page repair feature. We can say that it is the most flexible and useful solution of Always On SQL server.

Microsoft SQL Server Replication

Used for more reporting since it is replicated with SQL syntaxes. Allows table-based replication then you can create new indexes or delete unused ones. To give examples of replication tools dbVisit, Golden gate, Striim etc.

Microsoft SQL Server LogShipping

Another disaster recovery centre solution. Can be config at the database level. Passive node can be open read/only mode.

This website uses cookies and asks your personal data to enhance your browsing experience.