CODEWITHSUNDEEP
sql-serverdatabase-mirroring
user3807918
user3807918

Reputation: 375

Using DFS-R instead of mirroring on SQL Server

I want to do mirroring on SQL Server. While mirroring is better, only Enterprise can do this and the licence cost is an issue. I can use SQL Server standard which allows DFS-Replication not mirroring.

As I need 2 SQL Servers - main and backup - and only one database on them - what would stop me using DFS-R as a solution? Can the database files be too large for DFS-R?

Upvotes: 0

Views: 689

Answers (1)

David Browne - Microsoft
David Browne - Microsoft

Reputation: 89416

Mirroring is deprecated. You don't want to use it.

Standard Edition supports

Basic Availability Groups

Always On Basic Availability Groups provide a high availability solution for SQL Server from version 2016 and above on Standard Edition.

which are the replacement for Database Mirroring on Standard Edition. Or you can use

Log Shipping

SQL Server Log shipping allows you to automatically send transaction log backups from a primary database on a primary server instance to one or more secondary databases on separate secondary server instances.

Upvotes: 1

Related Questions