question

VijayKumar768 avatar image
0 Votes"
VijayKumar768 asked ErlandSommarskog commented

SQL Server 2016 Alwayon Disk space issue

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-generalsql-server-transact-sqlsql-server-migration
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered ErlandSommarskog commented

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.

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Currently this is Async mode.

If Logdrive on secondary Node full, The primary is not sync the data with secondary.
In this case where is the outage? Because Primary is serving. only thing is the no data sync. (Or secondary is not ready to accept connections from Primary)

Please correct me if i am wrong.

0 Votes 0 ·

Maybe then the secondary will stop, but if the primary cannot set log records to the secondary, the log will grow and 1TB later...

And if the secondary is down and behind, this means that you no longer have a HA solution.

By the way, why do you have an Availability Group?

0 Votes 0 ·