You are the SQL administrator for your company. You manage two SQL Server 2008 instances named SQL1 and SQL2 . Each instance maintains its own error log.
You discover that the hard drive on which the error log for SQL1 resides is full. You delete non-vital informationfrom the hard drive to free up space.
After cleaning up the hard drive, you decide that you want to start a newerror log. What should you do? (Choose two. Each correct answer represents a complete solution.)
A.
Restart SQL1.
B.
Restart the computer on which the SQL1 instance resides.
C.
Run the sp_cycle_errorlog system stored procedure.
D.
Run the sp_cycle_agent_errorlog system stored procedure.
Explanation:
You have two options for starting a new error log:
* Restart SQL1 .
* Run the sp_cycle_errorlog system stored procedure.If you are able, you can simply restart the instance. A new error log is started with every instance restart.However, if you do not want to restart the instance, you can run the sp_cycle_errorlog system stored procedureto generate a new error log. The SQL Server error logs are stored in the Program FilesMicrosoft SQLServerMSSQL.nMSSQLLOG directory by default. The current error log is named ERRORLOG . The previoussix error logs are also maintained in the directory and named ERRORLOG.1 , ERRORLOG.2 , and so on, with themost recent log ending with the .1 extension. The SQL Server error log can be viewed using a text editor or SQLServer Management Studio. You should not restart the computer on which the SQL1 instance resides. It is not necessary to restart the entirecomputer. You only need to restart the SQL Server 2008 instance. You should not run the sp_cycle_agent_errorlog system stored procedure. This system stored procedure creates a new SQL Server Agent error log, not a SQL Server error log.
Objective:
Monitoring and Troubleshooting SQL Server
Sub-Objective:
Locate error information.
References:
TechNet > TechNet Library > Server Products and Technologies > SQL Server > SQL Server 2008 > ProductDocumentation > SQL Server 2008 Books Online > Database Engine > Operations > Monitoring > MonitoringEvents > Monitoring the Error Logs > Viewing the SQL Server Error Log TechNet > TechNet Library > Server Products and Technologies > SQL Server > SQL Server 2008 > ProductDocumentation > SQL Server 2008 Books Online > Database Engine > Technical Reference > Transact-SQLReference > System Stored Procedures (Transact-SQL) > SQL Server Agent Stored Procedures (Transact-SQL)>sp_cycle_errorlog (Transact-SQL)