C# Corner
Tech
News
Videos
Forums
Trainings
Books
Events
More
Interviews
Jobs
Live
Learn
Career
Members
Blogs
Challenges
Certifications
Bounties
Contribute
Article
Blog
Video
Ebook
Interview Question
Collapse
Feed
Dashboard
Wallet
Learn
Achievements
Network
Refer
Rewards
SharpGPT
Premium
Contribute
Article
Blog
Video
Ebook
Interview Question
Register
Login
.NET
ADO.NET
Android
ASP.NET
C#
Databases & DBA
Design Patterns & Practices
Java
Learn iOS Programming
OOP/OOD
SharePoint
Software Testing
Web Development
WPF
View All
1
Reply
What is database logs?
Rajeev Kumar
2y
1.7k
0
Reply
Delete Row
Delete Column
Insert Link
×
Insert
Cancel
Embed YouTube Video
×
Width (%)
Height (%)
Insert
Cancel
Table Options
×
Rows
Columns
First row as header
Create Table
Insert Image
×
Selected file:
Alignment
Left
Center
Right
Select an image from your device to upload
Upload to Server
Cancel
Submit
What is database logs?
Database logs are a record of all the activities that occur in a database management system. They keep track of data changes, user accesses, and system events. These logs serve several important purposes:Auditing: Database logs can be used to track who did what and when in the database, providing a basis for auditing and compliance.Debugging: Logs can help diagnose problems with the database and application, and provide valuable information for debugging and troubleshooting.Recovery: In case of a system failure, logs can be used to restore the database to a previous state, or to recover lost or corrupted data.Performance Monitoring: Logs can help monitor database performance and identify potential performance bottlenecks.Security: Logs can help detect and prevent security breaches by providing a record of suspicious or unauthorized activities.It is important to regularly review and manage database logs to ensure their usefulness and to keep them from becoming too large and impacting performance. It is also important to secure the logs to prevent unauthorized access to sensitive information.
Manoj Kumar Duraisamy
2y
1
What is use of @@ROWCOUNT in T-Sql with Procdure?
What is the output of the Following statement?
Message