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'

How are the unique and primary key constraints different?

1121

---

Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

1026

---

Do you know data definition language, data control language and data manipulation language?

1084

---

How to get a list of columns in a view using the "sp_help" stored procedure?

1085

---

Explain iaas, paas and saas?

92

---

Explain activity monitors

1127

---

Do you think BCNF is better than 2NF & 3NF? Why?

1338

---

Explain the steps to use transact-sql cursor?

1149

---

What is sql sandbox in sql server?

1288

---

How to enter unicode character string literals in ms sql server?

1112

---

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

1124

---

How to start sql server browser service?

1176

---

What is constraints and its types?

995

---

Explain filtered indexes benefits?

1042

---

What do you understand by hotfixes and patches in sql server?

1028

---