Answer Posted / 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'

Explain what is the purpose of sql profiler in sql server?

1018

---

How to create function without parameter in sql server?

1003

---

What is table join?

1071

---

How to run sql server 2005 books online on your local system?

927

---

What are the advantages of paper records?

914

---

Why we need to use secondry database file? though, we can do same work using primary database file also.

6774

---

Show Practically Sql Server Views are updatable?

1064

---

How to replace given values with null using nullif()?

933

---

What are the advantages of policy management?

954

---

What are the various editions of sql server 2017 that are available in the market?

852

---

Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?

128

---

What are .mdf files?

893

---

What is isolation levels?

973

---

How many columns can we include on clustered index ?

945

---

What are indexes in sql?

1191

---