Storage getting full with transaction logs

0

We have RDS MS SQL with latest version. Our storage is getting full with transaction logs every time I increase storage it keep getting full with logs. How this can be overcome.

2개 답변
0

Have you considered storage autoscaling feature. Transaction logs are critical for recovery.

I'd suggest you to check Managing capacity automatically with Amazon RDS storage autoscaling and see if this helps in your case.

Here is a related re:Post thread.

Hope you find this useful.

Comment here if you have additional questions, happy to help.

Abhishek

profile pictureAWS
전문가
답변함 9달 전
  • Yes, autoscaling is already been enabled. However, even transactions logs are important how we can manage it by keeping logs safely manner, by making enough space for db.

  • Have you enabled transaction log backup copy?

  • Please refer these:

    Also, I'm curious, if you are seeing any issue with Storage Auto Scaling, I've included a thread in my answer which talks about that.

  • There is no problem with autoscaling. Does that imply that if I back up logs to an S3 bucket, transaction logs will be cleared fron db storage? Is this what you mean to say here?

0

Here use s3 bucket to store logs and then monitor it, you can use lambda function to store logs into s3 bucket

Afshaar
답변함 9달 전
  • Can you share steps also will it be cleared logs from rds?

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인