New answers tagged

1 vote

Can someone help explain the specifics of why a DBA would be against database clustering?

In addition to the what the Oracle answers mentioned, you run into similar hurdles with SQL Servers too. The defacto solution for HA/DR in SQL Server is setting up failover clusters via AlwaysOn ...
user avatar
  • 25.6k
1 vote

Can someone help explain the specifics of why a DBA would be against database clustering?

Speaking as a DBA with 30 years experience with Oracle, and about half of that with Oracle RAC, I can say that if your goal is reduced downtime, then RAC (active-active clustering with shared storage) ...
user avatar
  • 2,258
0 votes

Can someone help explain the specifics of why a DBA would be against database clustering?

In case of Oracle Dataguard and Oracle RAC (especially) it adds additional complexity. Like a lot of complexity(dedicated VLAN for interconnect, FibreChannel shared storage, several IP addresses, you ...
user avatar
  • 1,474
3 votes
Accepted

SQL Server fix deleted mdf

The normal process to recover from a storage failure is to backup the tail of the log (if possible), restore from your last full backup, restore the most recent differential backup (if you do those), ...
user avatar
  • 24.5k
2 votes
Accepted

Does the SQL AG based corruption resolution work for a enterprise edition read scale AG and for basic AG?

SQL provides 2 kinds of AG architecture. I wouldn't call those architectures, I know this wasn't your question, but it needed to be pointed out. Does the SQL AG based corruption resolution work for ...
user avatar

Top 50 recent answers are included