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 the difference between a view and a stored procedure?

0 Answers  

---

What is the maximum length of an alert name?

0 Answers  

---

Write a sql query to display the current date?

0 Answers  

---

i need some interview questions on sql server developer plz any onee send some links.

2 Answers  

---

Explain the different types of backups available in sql server? : sql server database administration

0 Answers  

---

Explain various On-Delete options in a DB table. Which is the default option?

0 Answers   Akamai Technologies,

---

What is the difference between system objects and user objects?

0 Answers   HCL,

---

What is the difference between functions and stored procedures?

0 Answers   Accenture,

---

when you create a database how is it stored? : Sql server database administration

0 Answers  

---

What is the use of SCOPE_IDENTITY() function?

2 Answers  

---

What are the advantages of paper records?

0 Answers  

---

What is a covered index?

0 Answers  

---