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

To automatically record the time on which the data was modified in a table, which data type should you choose for the column?

0 Answers  

---

Explain difference between control flow and data flow?

0 Answers  

---

What are dml triggers and types of dml triggers?

0 Answers  

---

Can we passed multiple recordset(set of records) using a Stored Procedure

2 Answers  

---

write the query for taking database restore in sql?

2 Answers  

---

What is the difference between push and pull subscription? : sql server replication

0 Answers  

---

Why do we use stored procedures in sql server?

0 Answers  

---

How to assign null values to variables or columns?

0 Answers  

---

Explain about system stored procedure?

0 Answers  

---

How can u get the number of pupils connecting the database?

1 Answers   Cap Gemini,

---

How can I get data from a database on another server?

0 Answers  

---

Can you explain what is indexed view? How to create it?

0 Answers  

---