SQL Server 2016 Alwayon Disk space issue

Vijay Kumar 2,016 Reputation points
2021-10-29T19:56:15.21+00:00

Hi Team,

We have SQL 2016 AlwaysOn with 2 Nodes (Primary+1 Secondary)

We had some issue with 3rd party backup tool, so team is working on that.

The issue is in Primary Log Drive size is 5 TB and Secondary 4 TB (Requested to increase additional storage But takes time)

Now my question is, due to issue with Backup tool the log backup is not happning.

What happens if log drive is secondary is full?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,705 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
494 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,552 questions
0 comments
Accepted answer
  1. Erland Sommarskog 101K Reputation points MVP
    2021-10-29T21:44:00.08+00:00

    I guess that you put these databases on an Availability Group, because they were deemed critical enough to warrant an HA/DR solution. And now you are telling me that log backups are not happening? That could be acceptable with a tier-3 system, but not a system that requires an HA solution. If the backup tool is not working, I would schedule native backups in the meanwhile to minimise the damage in case of a disaster. You do have an SLA with an RPO and RTO don't you?

    As for your question, I can't but see that there will be an outage, as it will not be possible to write to the database.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest