Answer / hari

Log shipping is the different than the Replication .

Logs can be shipped to stand by server. where the database
should be in non-recovery or standby mode.you can you have
stand by server ready when failure of primary server occurs
or you can even use standby server for read only adhoc
queires by users in your organization to distribute load
and also use the same server in event of main server failure

As per replciation there are 3 types of repliciation .
Depending on the transcations being performed and the
requirement you implement it.

How to add a new dsn with the odbc driver for sql server?

0 Answers  

---

what is the difference detween pairwise comparison subquary and non pairwise comparison subquary?

2 Answers  

---

Can a stored procedure call another stored procedure. If yes what level and can it be controlled?

2 Answers  

---

Which stored procedure will you be running to add a linked server?

1 Answers  

---

Define self join in sql server joins?

0 Answers  

---

---

Explain the stored procedure?

0 Answers  

---

What are the requirements for sql server 2016?

0 Answers  

---

What have included columns when we talk about sql server indexing?

0 Answers  

---

What is update locks?

0 Answers  

---

What happens when unicode strings concatenate with non-unicode strings?

0 Answers  

---

What is the use of Port no?

1 Answers   Wipro,

---

What are the types of dml?

0 Answers  

---