Answer / anwar hayat

To change the location of your log backup files, you have
to update whatever process is generating them. If it is a
Maintenance Plan then you can adjust it inside the
Maintenance Plan properties. To change the location of the
SQL Agent log, expand the SQL Server Agent Node in SSMS,
right click the ErrorLogs folder and click Configure, and
change the path there. Or you can do it with TSQL:
Code Snippet
USE [msdb]
GO
EXEC msdb.dbo.sp_set_sqlagent_properties
@errorlog_file=N'D:\Srvapps\Microsoft SQL Server\MSSQL.1
\MSSQL\LOG\SQLAGENT.OUT'

Answer / sneha daultani

By default SQL Server ERRORLOG is stored in "C:Program FilesMicrosoft SQL ServerInstanceFolderMSSQLLog" folder. The ERRORLOG location is configured as a startup parameter for SQL Server Service.

To change the location of ERRORLOG you need to modify the startup parameter -e.

Restart SQL Server Service to apply changes. 

Can you force a query to use a specific index?

0 Answers  

---

Explain the categories of stored procedure?

0 Answers  

---

What are different types of constraints?

0 Answers  

---

What is database black box testing?

0 Answers  

---

How you can get a list of all the table constraints in a database?

0 Answers  

---

Is mysql better than sql server?

0 Answers  

---

What is the impact on other user sessions when creating indexes?

0 Answers  

---

How can you find out which stored procedures are recompiling?

0 Answers  

---

How to connect php with different port numbers?

0 Answers  

---

Explain what are the events recorded in a transaction log?

0 Answers  

---

What is awe?

0 Answers  

---

What is the disadvantage of using subquery exact after a select statement?ex. select (select * from sometable)

1 Answers  

---