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'

What is the difference between for auto and for nested?

1063

---

Can a rule be bound to any column of any data type?

1024

---

What is the difference between an index and a unique index?

1044

---

How do you check sql server is up and running?

1045

---

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1107

---

Tell me what is difference between view and materialized view?

980

---

What is difference between rownum and row_number?

1022

---

Does sql server 2000 clustering support load balancing?

1024

---

What is a matrix in ssrs?

158

---

How to download microsoft sql server 2005 express edition?

1092

---

What are the steps to insert a table?

991

---

Tell me what is sql profiler?

1083

---

What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?

1018

---

What are the properties of the transaction?

1051

---

What is ems sql management studio? : sql server management studio

1163

---