CODEWITHSUNDEEP
sql-serverdatabasesql-server-2016
Chris
Chris

Reputation: 336

SQL Server Transaction Logs

We are running an AlwaysOn SQL Server database with 2 servers. All runs great but we do have massive data changes every day. Our DB is around 60GB but we update data very often and take trans log backups every day but still growth exceeds 100GB to 300GB on transaction logs.

Is there any way to keep the transaction logs to 60GB (recommended size) and if it exceeds that, overwrite previous logs?

Any suggestions are appreciated.

Thank you.

Upvotes: 0

Views: 220

Answers (1)

JERRY
JERRY

Reputation: 1173

If you don't need Transaction Log for DR purpose then just make it in SIMPLE recovery model and take a full backup once in a day. and i don't understand why you are taking Transaction log once in a day.

I think so it should be with in at least 15 mins interval. Because you will loss of the data after last Transaction backup. so as a process and good feature of MS SQL Server, make it with small interval and move it to another server for safe purpose as part of Log-Shipping.

Upvotes: 1

Related Questions