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

How do I trace a query in sql server?

964

---

How can I create a new template for import ? : sql server management studio

1082

---

what are constraints? Explain different types of constraints? : Sql server database administration

997

---

How to read data in a table with "select" statements?

977

---

How to test odbc dsn connection settings?

1043

---

What is database replication? What are the different types of replication you can set up in sql server?

964

---

what's the maximum size of a row? : Sql server database administration

1098

---

How you can find out if an index is useful to the optimizer?

944

---

How to return the top 5 rows from a select query in ms sql server?

1152

---

How to use copy and concatenate commands in SQL?

1152

---

What is difference between index and primary key?

1105

---

What encryption security is available in sql azure?

101

---

Explain system scalar functions?

1007

---

What are the basic features of a trigger in ms sql server?

1206

---

Explain primary key?

975

---