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. 

What is collation sensitivity?

1 Answers  

---

Advantages and Disadvantages of Cursor?

15 Answers   Polytechnic, TCS, Zenith,

---

Which joins are sql server default?

1 Answers  

---

What are the events recorded in a transaction log?

1 Answers  

---

Please give me queries for the following 1. To get the count of duplicate records. 2. A query to delete the duplicate records.

3 Answers   247Customer,

---

Does hive support indexing?

1 Answers  

---

Is it possible to call a stored procedure within a stored procedure?

1 Answers  

---

Do you know how to implement service broker?

1 Answers  

---

Does transparent data encryption provide encryption when transmitting data across the network?

1 Answers  

---

What is Index ? Explain its Types?

2 Answers   ADP,

---

How to create function with parameter in sql server?

1 Answers  

---

when we use function instead of procedure? plz tell me the situation with ex?

3 Answers   IBM,

---