Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
1
Reply
How to restrict the auto log in SQL Transaction?
Bhuvanesh Mohankumar
Nov 15 2016 9:32 AM
271
Reply
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.
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
1
)
Next Recommended Forum
Protect Audit Logging from tampering?
Delete .ndf file