Learn More
Resend Email
22
sqlsandwiches
7y

Please explain it to me again why you need more space for your 200 mb database that has a 500 gb log file.

rant
Favorite
Ranter
Comments
  • 0
    7y
    I too have this question but never found an answer for it, guess I"m looking in the wrong place because all said similar to this: https://dba.stackexchange.com/quest...
  • 0
    7y
    In my case it's a DB in simple mode. A job that processes some data does it RBAR, so that blows up the log file. But...it will take too long to recode it so we need to get more space.
  • 2
    7y
    How far back do those logs go? And are they even relevant?
  • 1
    7y
    Just rotate them. find -m7 dir -exec rm {}\;
    Why are they needed if you're not rolling back or rebuilding from a set point in time? Just curious.
devRant © 2021 Hexical Labs LLC
Privacy Policy  |  Terms of Service
Add Comment