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. 

You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?

0 Answers  

---

How to determine the service pack currently installed on SQL Server?

4 Answers   HCL,

---

How do I run sql server 2014?

0 Answers  

---

What is executereader?

0 Answers  

---

Where are SQL server users names and passwords are stored in sql server?

0 Answers   HCL,

---

What is a scheduled job or what is a scheduled task?

0 Answers  

---

Can group functions be mixed with non-group selection fields in ms sql server?

0 Answers  

---

What are the dmvs?

0 Answers  

---

What is the function of inner join?

0 Answers  

---

What are the steps to insert a table?

0 Answers  

---

How to select an exiting database using mssql_select_db()?

0 Answers  

---

Explain the microsoft sql server delete command?

0 Answers  

---