Which of the following statements is TRUE about SQL Server error logs?
Which of the following statements is TRUE about SQL Server error logs?
SQL Server error logs contain user-defined and specific system events, and also include the IP addresses of SQL Server client connections. This allows for detailed tracking of client interactions with the SQL Server, essential for monitoring and forensic investigations. The other options either misunderstand the specific contents of the SQL Server error logs or refer to different tools or functions within SQL Server.
https://info-savvy.com/determine-the-database-evidence-repositories-and-collect-the-evidence-files/
Answer is C: The error logs also contain the IP address of SQL server-client connections.
It's C. The CFHI v10 manual pg 709 says "The SQL Server error logs record user-defined and specific system events. The error logs also contain the IP address of SQL server-client connections."
your sentence is correct but answer is D
Answer is D
According to the CHFI v10 book the answer is D, but also C. ..."The SQL Server error logs record user-defined and specific system events. The error logs also contain the IP address of SQL server-client connections. A new error log file is created when a new SQL Server instance occurs."
I think C is correct. CHFI v10 book says "The SQL Server error logs record user-defined and specific system events. The error logs also contain the IP address of SQL server-client connections" So C and D could be correct... However, according to info-savvy there are 3 files - Database & logs files - Trace files records - SQL Server error logs So Trace files records are not in the SQL Server error logs and D is not correct. https://info-savvy.com/determine-the-database-evidence-repositories-and-collect-the-evidence-files/
“D” is wrong because the “Trace Files” are not in the error logs. The most correct is the letter “C”. (Module 11 Page 1056 do CHFIv10 book)
Not B < SQL Server Profiler is used to view the trace files, not the error log file. C < SQL Server error logs record user-defined events and specific system events. The error logs also contain the IP Address of SQL Server client connections.
Error logs contain IP address of SQL Server client connections
SQL Server error logs can include details such as the IP addresses of client connections, which can be useful for forensic investigations. The SQL Server error logs can include details such as the IP addresses of client connections, which can be useful for forensic investigations. The other statements are either incorrect or refer to different functionalities within SQL Server. other statements are either incorrect or refer to different functionalities within SQL Server.