Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with transaction-log
Search options not deleted
user 225249
Transaction log is a list/history of modification executed by a database management system to guarantee ACID properties over crashes or hardware failures.
0
votes
1
answer
62
views
SQL 2017 log reuse issue
I have a SQL 2017 Enterprise server where more and more VLFs are being consumed and none are being released. Log backups are running every 15 minutes. It is in an AG but this is working correctly (rea …
- 11
1
vote
SQL 2017 log reuse issue
What I didn't know is that for databases in AGs, VLFs can remain with a status of 2 even after they are freed up by a backup.
https://www.sqlskills.com/blogs/paul/lazy-log-truncation-or-why-vlfs-might …
- 11