How to restrict the auto log in SQL Transaction?
We have numerous SQL Transaction occurs daily with our application.
The transaction log are so much, the server space goes out of memory.
What I actually need?
Can I reduce the logging items, say only certain transactions need to be logged and discard others.
If the logs are more than a week time older, can that be automatically deleted or override he older logs, if the memory is less.
What we tried?
Tried to auto shrink log files, but not sure about implementation, so it failed to work as expected.
Thanks in advance.