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 will you know when statistics on a table are obsolete?

0 Answers  

---

How to set a database state to offline in ms sql server?

0 Answers  

---

Is a primary key unique?

0 Answers  

---

How to concatenate two strings in SQL Server.

0 Answers   HCL,

---

What is sql server used for?

0 Answers  

---

---

Does sql server 2016 have ssms?

0 Answers  

---

where the connection string store in the database

0 Answers   HCL, Wipro,

---

What happens on checkpoint?

0 Answers  

---

What is the server name in sql server?

0 Answers  

---

What are the advantages of using stored procedures?

0 Answers  

---

in how many ways we can use count()

2 Answers  

---

which is best institute to learn sql server in ameerpet or sr nagar or maithrivanam?please help

3 Answers  

---