Answer / anwar

Four jobs will create on logshipping

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

Answer / gaurdas06

Four jobs will create :
1. Backup job - to take the backup of the logs
2. Copy job - to copy the logs to the destination/secondary server
3. Restore job - to restore logs on the target server and lastly
4. alert job - to send alert or report for any errors

Thnx

Andy

Answer / yuvarajputtur

my josbs supper managemen jobs

What is an expensive query?

0 Answers  

---

What is normalization and its types?

0 Answers  

---

What are the lambda triggers?

0 Answers  

---

Can you create UNIQUE and PRIMARY KEY constraints on computed columns in SQL Server 2000?

3 Answers   Infosys,

---

Explain the categories of stored procedure?

0 Answers  

---

---

How can delete duplicate records in cte in sql server?

0 Answers  

---

Using the customer, and order table in northwind database, please write a query to produce xml?

0 Answers  

---

Can anybody explain me cold backup and hot backup?

3 Answers   TCS,

---

What is dynamic cursor in SQL SERVER?

0 Answers  

---

How to call a function from a stored procedure in SQL Server ?

0 Answers   HCL,

---

What is the system function to get the current user's user id?

3 Answers   TCS,

---

Which sql server table is used to hold the stored procedure script?

0 Answers  

---