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 difference between foreign key and unique key?

0 Answers  

---

What is the default value of CHAR type?

10 Answers   Bosch,

---

In what three ways is the return statement used in a stored procedure?

0 Answers  

---

What is PROJECTION Operation?

0 Answers   Infosys,

---

What is updatable resultset?

0 Answers  

---

What is the command dbcc checkdb used for?

0 Answers  

---

What is a virtual table in sql?

0 Answers  

---

What about UPDATESTATISTICS ?

2 Answers   HCL, Intelligroup,

---

Can you tell me some of the common replication dmv's and their use? : sql server replication

0 Answers  

---

What are the disadvantages of indexes?

0 Answers  

---

Does the order of columns in update statements matter?

0 Answers  

---

What is the stuff?

0 Answers  

---