-2

By replicate entire sql server I mean:

Databases

Logins

Jobs

And absolutely every other aspect of sql server.

The only SQL technology to achieve this, assuming fault tolerant SAN, is failover clustering instance (FCI)? HA achieved via FCI and DR achieved via SAN RAID.

All other SQL technologies only allow database level replication without logins, jobs, etc.

Note: this question is only about sql technology, not any 3rd party tools.

7
  • Raid is not a DR technique.
    – vonPryz
    Oct 8 at 10:19
  • For example RAID 1 is mirroring. Raid 5 is based on parity. Raid 10 is also mirroring. I'm trying to imply that there will not be a disaster even if the disk crashes. So it gives implicit DR.
    – variable
    Oct 8 at 11:00
  • Raid is not a DR technique but about fault tolerancy. Imagine there's a fire in your storage cabinet. All the disks in the Raid array are now burned. An update missed where and now the customers table has lost account numbers. What was your Raid-based DR plan, again?
    – vonPryz
    Oct 8 at 11:08
  • 1
    DR is about extreme that's why it is called disaster recovery, not "oops, I made a small error, no biggie, just gonna rollback and rerun the query" -recovery. For example, MS docs have DR introduction's about losing datacenter because of an earthquake or flood. If that's what you are not worried, consider re-writing the question by explaining what threats you are trying to mitigate, not about what capabilities some technique has or has not.
    – vonPryz
    Oct 8 at 11:42
  • 1
    Replicating Jobs and Logins are not a requirement for a DR solution. HA/DR applies and is evaluated at a database level. Generally speaking (though I'm not going to say absolutely - I'm not a Sith :) your user databases are more important to consider DR on, as opposed to the system databases which usually change less frequently and you should be backing up anyway. A synchronous AlwaysOn Availability Group is one way to achieve HA/DR. SSIS and Replication can also be used for DR depending on your RPO and how you use those tools. There are solutions for setting up DR on the system DBs too.
    – J.D.
    Oct 8 at 12:33

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.