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.

What is join and name different type of joins?

0 Answers  

---

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

2 Answers  

---

What options are available to audit login activity? : sql server security

0 Answers  

---

What is sql stored procedure?

0 Answers  

---

What happens if you add a new index to large table?

0 Answers  

---

What is importing utility?

0 Answers  

---

what is Archive old data?

1 Answers  

---

What are audit control procedures?

0 Answers   Ernst Young, Thomson Reuters,

---

What does the update command do?

0 Answers  

---

How to convert binary strings into integers in ms sql server?

0 Answers  

---

Can you explain some of the DTS problems?

1 Answers   UBS, Wipro,

---

What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?

0 Answers  

---