Skip to main content
Share Your Experience: Take the 2024 Developer Survey
5 votes
Accepted

Running sp_repldone on a secondary node of an Availability Group with @reset = 1 not working

For background, I'm assuming this is a custom CDC solution, and the regular CDC jobs aren't running to populate the change tables and run sp_repldone, and so you must run sp_repldone to enable the log ...
David Browne - Microsoft's user avatar
2 votes

2x SQL Server 2019 in AlwayOn group - how to remove transaction log

There are supposed to be some way how to purge the log by doing some kind of backup, but never found real help on that. They're called Transaction Log backups. For a database that's set to the Full ...
J.D.'s user avatar
  • 37.9k
2 votes

2x SQL Server 2019 in AlwayOn group - how to remove transaction log

Simply put, we don’t need the log, we don’t want the log, how to get rid of that? You don't. SQL Server requires it to run and Always On requires it to function properly.
Sean Gallardy's user avatar
2 votes

Can we take a copy-only backup for filegroups on the SQL Server from a secondary HA replica?

The Docs state this is possible (emphasis mine): BACKUP DATABASE supports only copy-only full backups of databases, files, or filegroups when it's executed on secondary replicas. Copy-only backups ...
Sean Gallardy's user avatar
1 vote

Availability group failover-tempdb

Does anyone know if SQL AG will initiate automatic failover to secondary if tempdb is full in primary ? It won't fail over, there's no problem with the databases and the instance is not failing ...
Sean Gallardy's user avatar
1 vote

Preferred seconday backup in AG - what about the primary ? Shows no backups taken

The most recent backup time is pulled from msdb, which is not joined to the Availability Group (each replica has it's own copy of system databases). To get accurate information about the last backup ...
Dan's user avatar
  • 646

Only top scored, non community-wiki answers of a minimum length are eligible