What Are SQL Server Logs? Where Are SQL Server Logs Stored?

Asked By sherrydlongo 50 points N/A Posted on - 01/16/2017

What are the types of SQL server logs? Where are SQL server logs stored?

• Status: Open
• Question Views: 474
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Server Hardware
• Question Tags: SQL server logs

Answered By phoebegirl 0 points N/A #285647

What Are SQL Server Logs? Where Are SQL Server Logs Stored?

Server creates and maintains a log file automatically which are known as server logs. SQL is a server, and it manages few log files which are known as SQL server logs.SQL Server logs are mainly of 5 types namely error log, event log, agent log, profiler log and set up the log.

Error log helps in rectifying system problems. SQL Windows event log mainly contains mainly three types namely application log; which records events, security log; which records authentication information, and system log; which records service start up and shut down information. Agent log is the main SQL server log as it maintains and stores all the log files. Profiler logs checks and saves the system’s database and copies it to a file for future purpose. Lastly, the setup log helps in investigating the cause by looking at the file’s log.

About phoebegirl

Questions
6

Answers
7

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 01/16/2017
• Question Category: Server Hardware