Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Cleaning or Rotating vault_log.ldf #648

Closed
JeffAlyanak opened this issue Feb 2, 2020 · 7 comments · May be fixed by #5433
Closed

Cleaning or Rotating vault_log.ldf #648

JeffAlyanak opened this issue Feb 2, 2020 · 7 comments · May be fixed by #5433

Comments

@JeffAlyanak
Copy link

I'm wondering what the best method would be for rotating or clearing the mssql vault_log.ldf. On my install, it has ballooned to be much larger than the vault itself and I would like to know the best way to deal with it.
@kspearrin
Copy link
Member

This isn't a file you can rotate. It is the transaction log for the database. See https://stackoverflow.com/questions/826789/what-is-the-ldf-file-in-sql-server

@JeffAlyanak
Copy link
Author

My transaction log has ballooned to be many gigabytes in size. If it can't be rotated, can it be shrunk with dbcc shrinkfile or otherwise reconfigured to be smaller.

@Starbase12
Copy link

Starbase12 commented Jan 14, 2021 •
edited
Loading

If I understood correctly tha ldf-files are sql-transaction logs. As soon as there is no fully working backup routine in the background, the transaction log will will get bigger and bigger. Is there a way to permanently change the "database recovery mode" to "SIMPLE" for my bitwarden instance?

@Starbase12 Starbase12 mentioned this issue Jan 14, 2021
Closed
@zadjadr zadjadr mentioned this issue Aug 21, 2023
Open
@FingerlessGlov3s
Copy link

My vault_log.ldf file is currently 1.2G with a vault.mdf size of 72M.

Is there any news on getting a proper fix on the cleaning up the log file?

@zadjadr
Copy link

zadjadr commented Jan 23, 2024

My vault_log.ldf file is currently 1.2G with a vault.mdf size of 72M.

Is there any news on getting a proper fix on the cleaning up the log file?

I created a PR in August 2023, but I have not gotten any reaction or feedback to it..

@FingerlessGlov3s
Copy link

My vault_log.ldf file is currently 1.2G with a vault.mdf size of 72M.
Is there any news on getting a proper fix on the cleaning up the log file?

I created a PR in August 2023, but I have not gotten any reaction or feedback to it..

I tried to replicate what you changed in your PR, but I was getting errors when it went to do the DBCC SHRINKFILE, is the process still the same?

@Mart124 Mart124 mentioned this issue Feb 21, 2025
Open
@Mart124
Copy link
Contributor

Mart124 commented Feb 24, 2025

Please see #5433 for a safer approach.
Waiting for this fix to be merged 👍

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

[PM-18504] Enable SQL transaction log backup Mart124/server
6 participants
@kspearrin @FingerlessGlov3s @JeffAlyanak @Starbase12 @Mart124 @zadjadr