SQL AOG Transaction Log Backup nor working

Question

Hi guys,

we´ve got an AOG with 2 Nodes and actually 1 Database running on it.

Everything works fine - but the transact backup.

The database itself works, just the transact log wont backup.

Database is Full, Backup configured right, I´ve googled a lot but i couldnt find some usefull information.

What I´ve checked:

• Transaction Logs between the nodes are fine
• select log_reuse_wait_desc from sys.databases where name='Database' -> "LOG_BACKUP"
• SELECT sp.spid,st.text,sp.status,sp.login_time,sp.last_batch, sp.hostname,sp.loginame FROM sys.sysprocesses sp CROSS APPLY sys.dm_exec_sql_text(sp.sql_handle) st WHERE open_tran = 1 and sp.dbid=DB_ID('Database') order by login_time asc is empty

maybe someone got an idea?

Logfile grows actually

ty and happy new year
Philipp

Answer 1

Hi,

ty for your replies.

I´ve found the problem - i configured the AOG Backup to Backup prefered via secondary node.
The problem is that there are no writes @ secondary allowed - so the Transact Log couldnt Backup correctly.

I just changed to Backup primary and now it works fine.

Ty for your help
Regards
Philipp

Answer 2

How exactly are you running the BACKUP LOG commands?