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 do I connect to sql server database?

0 Answers  

---

Can you tell me the difference between DELETE & TRUNCATE commands?

15 Answers  

---

How to turn on the mssql api module in php?

0 Answers  

---

What is difference between commit and rollback when used in transactions?

0 Answers  

---

‘Order by’ is not allowed in a view how can you sort information from a view?

0 Answers  

---

What are the essential components of sql server service broker?

0 Answers  

---

Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.

0 Answers   HCL,

---

What is the purpose of the model database?

0 Answers  

---

wat will be the sql query to extract only last 3 records from table supose table hving thousands for records

19 Answers  

---

What are subqueries in sql server?

0 Answers  

---

could you please reply for these question: 1.About Use Apply? 2.Avoid cursors - When we have a situation that we can not avoid the use of cursor than what is the alternate solution? is there anything we can use instead of cursor to perform the desired task? which optiomize the peroformance too. 3.What is computed columns? Thanks in advance. Regards, Rupesh

3 Answers  

---

What do you understand by integration services in sql server?

0 Answers  

---