How do you clear the SQL Server transaction log?

Very important

To access the important data of the forums, you must be active in each forum and especially in the leaks and database leaks section, send data and after sending the data and activity, data and important content will be opened and visible for you.
You will only see chat messages from people who are at or below your level.
More than 500,000 database leaks and millions of account leaks are waiting for you, so access and view with more activity.
Many important data are inactive and inaccessible for you, so open them with activity. (This will be done automatically)

Pages (3): « Previous 1 2 3

Thread Rating:

591 Vote(s) - 3.51 Average
1
2
3
4
5

Options

How do you clear the SQL Server transaction log?

jerseywwk

Luxury

Posts: 0
Threads: 0
Joined: Jan 2023
Reputation: 0

Level: inf [ Level

]
Total Points: inf
Rank nan / 1
100% to upload Level

Activity inf / 1
99% to upload your Rank

Experience nan
100% to upload Experience

Points: 50

#21

07-31-2023, 09:39 AM

Slightly updated answer, for MSSQL 2017, and using the SQL server management studio.
I went mostly from these instructions

[To see links please register here]

I had a recent db backup, so I backed up the transaction log. Then I backed it up again for good measure.
Finally I shrank the log file, and went from 20G to 7MB, much more in line with the size of my data.
I don't think the transaction logs had ever been backed up since this was installed 2 years ago.. so putting that task on the housekeeping calendar.

« Next Oldest

Next Newest »

Pages (3): « Previous 1 2 3

Forum Jump:

Users browsing this thread:

1 Guest(s)