lo_oscar
asked on
SQL 2012 Always On - T-Log on Primary won't release
Hello All,
We have a 2 node SQL server 2012 AlwaysOn setup for automatic failover. Availability group is configured for the database in question. We have a rebuild indexes script created for this database back in 2008 R2, didn't cause the issue back then.
When we ran this maintenance script in 2012 after the DB is upgraded from SQL 200R2, the log got filled up on both log drives on Primary and Secondary. checked DBCC opentran and Loginfo, looks like the database had replication enabled but sys.databases says it's not. T-log backup was running every 15 mins, I tried to run it again but it couldn't truncate the logs in use by replication.
Unfortunately I don't know enough about AlwaysOn and how it utilizes SQL replication so is having a hard time trying to free up drive space. I tried to remove the database from the availability group but it didn't remove the "replication" status.
Any ideas? Thanks!
We have a 2 node SQL server 2012 AlwaysOn setup for automatic failover. Availability group is configured for the database in question. We have a rebuild indexes script created for this database back in 2008 R2, didn't cause the issue back then.
When we ran this maintenance script in 2012 after the DB is upgraded from SQL 200R2, the log got filled up on both log drives on Primary and Secondary. checked DBCC opentran and Loginfo, looks like the database had replication enabled but sys.databases says it's not. T-log backup was running every 15 mins, I tried to run it again but it couldn't truncate the logs in use by replication.
Unfortunately I don't know enough about AlwaysOn and how it utilizes SQL replication so is having a hard time trying to free up drive space. I tried to remove the database from the availability group but it didn't remove the "replication" status.
Any ideas? Thanks!
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.