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