Answer Posted / naga

log shipping:
1)backup job
2)copy job
3)restore job
4)alert job




database mirroring
1)database mirroring monitor job



replication
1)agent history cleanup job
2)distribution clean job
3)expire subscription clean job
4)replication agent checkup job
5)replication monitor refresh for distributor
6)reinitialize subscriptions having data validation failures

Why and when do stored procedure recompile?

967

---

What guidelines should be followed to help minimize deadlocks?

928

---

How can you find out which stored procedures are recompiling?

909

---

What causes index fragmentation?

976

---

Why is the need for data conversion transformations?

1033

---

What are the database roles? : sql server security

1146

---

Explain few examples of stored procedure over triggers?

1012

---

What is sql profiler. What are the default templates with it? : sql server database administration

1010

---

explain the storage models of olap? : Sql server database administration

938

---

What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?

887

---

Explain use of expression builder.

990

---

Explain identity in sql server?

988

---

What are the different types of data sources in ssrs?

196

---

What is acid properties?

1075

---

What is the difference between migration and upgradation in sql server?

1081

---