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 type of indexes physically sort data?

3 Answers  

---

How to retrieve field values using mssql_result()?

0 Answers  

---

Give me any three differences between Truncate and Delete.

0 Answers   Genpact,

---

What is temporal table?

0 Answers  

---

How to defragment table indexes?

0 Answers  

---

Do you know what is normalization of database? What are its benefits?

0 Answers  

---

what is the Enterprise manager(2000) and management studio (2005)?

2 Answers  

---

What is a partition key?

0 Answers  

---

How do I create an extended event in sql server?

0 Answers  

---

What is the Disadvantage of indexed sequential file.

0 Answers   HCL,

---

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

0 Answers  

---

How can I know what query is executing by by a particural user? (using sp id or any othe way.)

2 Answers  

---