MS SQL SERVER Transaction Log
-
Hi guys, Good Day! My back-end in my system is MS SQL SERVER, the major scenerios here are, it performs weekly autoupdate for the database and the data is so huge.. then, evrytime its updating the transaction log is occupying more space in the drive and encounters error if i set it to restrict file growth or in uncheck automatically file growth (it says that i need to set more size for the transaction logs or else it will not perform).. My problem here is how can i delete the tranasaction logs automatically or limit the size without encounter the error everytime i update the database, since my system does not need that? Hope your response, guys... Thank you in advance....
regards, JayR
-
Hi guys, Good Day! My back-end in my system is MS SQL SERVER, the major scenerios here are, it performs weekly autoupdate for the database and the data is so huge.. then, evrytime its updating the transaction log is occupying more space in the drive and encounters error if i set it to restrict file growth or in uncheck automatically file growth (it says that i need to set more size for the transaction logs or else it will not perform).. My problem here is how can i delete the tranasaction logs automatically or limit the size without encounter the error everytime i update the database, since my system does not need that? Hope your response, guys... Thank you in advance....
regards, JayR
Is your DB set to SIMPLE recovery model? Do you have AUTO_SHRINK set ON? Steve
-
Hi guys, Good Day! My back-end in my system is MS SQL SERVER, the major scenerios here are, it performs weekly autoupdate for the database and the data is so huge.. then, evrytime its updating the transaction log is occupying more space in the drive and encounters error if i set it to restrict file growth or in uncheck automatically file growth (it says that i need to set more size for the transaction logs or else it will not perform).. My problem here is how can i delete the tranasaction logs automatically or limit the size without encounter the error everytime i update the database, since my system does not need that? Hope your response, guys... Thank you in advance....
regards, JayR
You need to understand what the transaction log is and what it's used for. See this comment[^] and this comment[^] for details. I ought to turn those into an article.
Stability. What an interesting concept. -- Chris Maunder